/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 50622
 Source Host           : localhost
 Source Database       : ycchannel

 Target Server Type    : MySQL
 Target Server Version : 50622
 File Encoding         : utf-8

 Date: 09/15/2017 22:08:08 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `app_album`
-- ----------------------------
DROP TABLE IF EXISTS `app_album`;
CREATE TABLE `app_album` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '专辑名称',
  `bigpic` varchar(1024) DEFAULT NULL COMMENT '专辑大图',
  `minpic` varchar(1024) DEFAULT NULL COMMENT '专辑小图',
  `childapps` varchar(15000) DEFAULT NULL COMMENT '专辑下面子集',
  `status` varchar(2) DEFAULT NULL COMMENT '状态  0 显示在正在关注  1为你推荐子列表',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `app_album`
-- ----------------------------
BEGIN;
INSERT INTO `app_album` VALUES ('1', '123', '14866944957368e3181a1-7e2e-49e1-95d5-97103a80a37a.jpg', '14866944957380c759d4a-1733-410b-bc8a-e794012c02f8.jpg', null, '0', '2017-02-07 15:06:04'), ('2', '223', '148669386840895c2c877-2a2d-4f53-87dc-6387e274f58f.jpg', '1486693868411083798ff-cb50-4b5f-9c94-13d6b860c4a7.jpg', ',359,358,357,356,355,354,353,352,351,350,347,346,345,344', '1', '2017-02-01 21:06:08'), ('3', '335', '1486968583528d93d929b-b275-4c25-832d-d6865df4d9de.jpg', '1486968583530070130bc-996a-40bf-bb7c-48347edb6739.jpg', null, '0', '2017-02-13 14:49:43'), ('4', '443', '14870328942150ac90f55-c975-4613-a3f4-9a901ac34e3d.jpg', '1487032894230997209d3-ba35-4a33-a3f7-9d8eaf47475d.png', ',359,358,357,356,355,354,321,320,319,318', '0', '2017-02-13 15:15:12');
COMMIT;

-- ----------------------------
--  Table structure for `app_column`
-- ----------------------------
DROP TABLE IF EXISTS `app_column`;
CREATE TABLE `app_column` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(50) DEFAULT NULL COMMENT '应用名称',
  `ICON` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `app_column`
-- ----------------------------
BEGIN;
INSERT INTO `app_column` VALUES ('2', '旅行', null), ('3', '购物', null), ('4', '交通', null), ('5', '健康医疗', null), ('6', '图片', null), ('7', '工具', null), ('8', '教育培训', null), ('9', '快递查询', null), ('10', '天气查询', null), ('11', '投资理财', null), ('12', '票务', null), ('13', '阅读', null), ('14', '视频', null), ('15', '美食', null), ('16', '美妆', null), ('17', '体育', null), ('18', '表情包', null), ('19', '游戏', null), ('20', '求职', null), ('21', '音频', null), ('22', '自媒体', null), ('23', '社区', null), ('24', '房地产', null);
COMMIT;

-- ----------------------------
--  Table structure for `app_comment`
-- ----------------------------
DROP TABLE IF EXISTS `app_comment`;
CREATE TABLE `app_comment` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `USER_ID` int(11) DEFAULT NULL COMMENT '用户ID',
  `PROD_ID` int(11) DEFAULT NULL COMMENT '应用ID',
  `CONTENT` varchar(512) DEFAULT NULL COMMENT '评论内容',
  `STAR` int(1) DEFAULT NULL COMMENT '星级',
  `CREATE_DATE` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=228 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `app_comment`
-- ----------------------------
BEGIN;
INSERT INTO `app_comment` VALUES ('27', '18', '35', '不错,很实用', '5', '2017-01-12 16:16:40'), ('28', '18', '35', '不错,很实用', '5', '2017-01-13 16:29:43'), ('32', '18', '35', '不错,很实用', '5', '2017-01-13 17:11:53'), ('35', '9', '230', '个这小程序很好用。', '5', '2017-01-16 08:45:06'), ('36', '9', '244', '感觉摩拜单车没有小鸣好用。', '4', '2017-01-16 08:46:04'), ('37', '9', '195', '很好，送餐很快。', '5', '2017-01-16 08:48:41'), ('38', '2', '263', '不错', '4', '2017-01-16 18:40:14'), ('39', '9', '202', '很好用。', '4', '2017-01-17 11:51:05'), ('41', '4', '309', '好用', '5', '2017-01-19 11:46:55'), ('45', '2', '309', '不错', '2', '2017-01-19 15:59:30'), ('46', '2', '244', '功能和单车都很好用，只是平台服务态度不好。', '3', '2017-01-20 10:04:37'), ('47', '2', '35', '很好用。', '3', '2017-01-20 15:28:30'), ('48', '2', '72', '携程旅行网小程序，好用', '3', '2017-01-20 15:30:27'), ('49', '25', '310', '一款不错的交流平台。', '5', '2017-01-20 15:37:09'), ('51', '18', '309', '可以', '5', '2017-01-20 15:54:51'), ('52', '25', '310', '很不错的应用', '5', '2017-01-20 16:04:21'), ('59', '25', '310', '非常好用的小程序', '5', '2017-01-20 16:14:22'), ('60', '2', '310', '确实不错', '3', '2017-01-20 16:14:54'), ('61', '23', '311', '方便，试用', '5', '2017-01-20 16:47:58'), ('62', '23', '263', '可以用', '5', '2017-01-20 16:49:03'), ('63', '21', '310', '找到了聊的很投缘的朋友', '5', '2017-01-21 09:36:41'), ('64', '10', '310', '又一个休闲频道，赞一个~', '5', '2017-01-21 09:37:26'), ('65', '21', '309', '圈子里有一个共享照片的小程序，很好', '5', '2017-01-21 09:38:09'), ('66', '21', '35', '过六级就靠它了', '5', '2017-01-21 09:38:52'), ('67', '10', '70', '经典中的经典~赞一个~', '5', '2017-01-21 09:38:54'), ('69', '7', '45', '还不错哇，最主要是第一时间能找到重要信息，而且不用下载。直接扫码可用', '5', '2017-01-21 09:40:16'), ('71', '7', '46', '哈哈，真方便', '5', '2017-01-21 09:40:36'), ('72', '7', '47', '超级好用的', '5', '2017-01-21 09:40:50'), ('74', '7', '312', '小程序真心强大', '5', '2017-01-21 09:41:05'), ('76', '10', '67', '约个伴儿呗~哈', '5', '2017-01-21 09:41:10'), ('77', '21', '311', '狂暴纠结症患者福音！！！', '4', '2017-01-21 09:41:14'), ('79', '7', '313', '挺好的，扫码就可以用啦', '5', '2017-01-21 09:41:26'), ('82', '7', '262', '再也不担心我的手机内存不够了，直接扫码可以用了', '5', '2017-01-21 09:41:48'), ('83', '10', '72', '携程自动抢票功能~赞赞赞', '5', '2017-01-21 09:41:53'), ('89', '7', '264', '哈哈，跟朋友斗图再也不怕了。扫码就能斗图', '4', '2017-01-21 09:42:14'), ('90', '21', '46', '很好用，但是都买不起。', '3', '2017-01-21 09:42:31'), ('92', '7', '48', '66666，不错', '5', '2017-01-21 09:42:39'), ('94', '10', '76', '假期必备~', '5', '2017-01-21 09:42:50'), ('95', '7', '49', '很精准，不错', '5', '2017-01-21 09:42:56'), ('101', '7', '50', '已赚好几万，今年过年不愁了，挺好用，大神多', '5', '2017-01-21 09:43:28'), ('103', '21', '312', '每天种草一款美妆，很快就负资产 :)', '5', '2017-01-21 09:43:53'), ('104', '7', '64', '居然扫码就可以用了，小程序可以的', '5', '2017-01-21 09:44:01'), ('105', '7', '68', '哈哈哈，不怕老婆管我的私房钱了', '5', '2017-01-21 09:44:16'), ('108', '7', '77', '很准确，很好用', '5', '2017-01-21 09:44:34'), ('109', '7', '81', '以后苹果手机再也不能跟我装13了，我安卓也不怕没内存了，直接扫码就能用了', '5', '2017-01-21 09:45:08'), ('110', '7', '86', '哈哈哈，赚了不少，李杨', '5', '2017-01-21 09:45:23'), ('113', '7', '87', '每笔出入的账目都很清楚了', '4', '2017-01-21 09:46:32'), ('114', '21', '67', '买票很方便', '5', '2017-01-21 09:46:41'), ('148', '10', '244', '要交299!要交299!要交299!\n二代车很好骑', '5', '2017-01-21 10:00:50'), ('149', '29', '70', '去哪儿去哪儿', '5', '2017-01-21 10:01:44'), ('150', '29', '35', '查单词靠他了', '5', '2017-01-21 10:02:13'), ('151', '29', '135', '支持有道', '5', '2017-01-21 10:02:57'), ('152', '21', '244', '扫码就能骑车，好棒', '5', '2017-01-21 10:03:04'), ('153', '21', '198', '一直用滴滴叫车，很好，现在直接扫都不用下载了、', '5', '2017-01-21 10:04:56'), ('154', '21', '70', '光速抢票！！！！光速，赞', '5', '2017-01-21 10:06:46'), ('155', '10', '198', '不得不用，已经不实惠了', '3', '2017-01-21 10:07:51'), ('214', '23', '263', '可以用', '5', '2017-01-21 16:54:34'), ('215', '23', '263', '可以用', '5', '2017-01-21 17:42:15'), ('217', '23', '263', '可以用', '5', '2017-01-21 18:01:35'), ('220', '2', '358', '好应用', '5', '2017-01-21 19:33:58'), ('221', '25', '35', '好用，赞一个', '5', '2017-01-22 08:51:53'), ('222', '9', '317', '很好。', '4', '2017-01-22 10:12:47'), ('223', '9', '325', '试过一次，可以打折。', '4', '2017-01-22 10:13:36'), ('224', '24', '315', '聊天等公交，brt不用切出微信啦', '5', '2017-01-22 16:20:00'), ('225', '25', '314', '好用', '5', '2017-01-23 10:53:52'), ('226', '25', '262', '还在纠结用什么词表达自己吗，直接上图斗起来。', '5', '2017-01-23 10:56:19'), ('227', '2', '321', '标杆', '5', '2017-02-14 10:58:23');
COMMIT;

-- ----------------------------
--  Table structure for `app_my_app`
-- ----------------------------
DROP TABLE IF EXISTS `app_my_app`;
CREATE TABLE `app_my_app` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `USER_ID` int(11) DEFAULT NULL COMMENT '用户ID',
  `PRODUCT_ID` int(11) DEFAULT NULL COMMENT '产品ID',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `app_my_app`
-- ----------------------------
BEGIN;
INSERT INTO `app_my_app` VALUES ('1', '1', '2'), ('2', '1', '3');
COMMIT;

-- ----------------------------
--  Table structure for `app_prod_lable`
-- ----------------------------
DROP TABLE IF EXISTS `app_prod_lable`;
CREATE TABLE `app_prod_lable` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `LABLE_NAME` varchar(100) DEFAULT NULL COMMENT '标签名',
  `DESCTION` varchar(200) DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `app_prod_lable`
-- ----------------------------
BEGIN;
INSERT INTO `app_prod_lable` VALUES ('1', '金融', null), ('2', '商业服务', null), ('3', '公益', null), ('4', '教育', null), ('5', '富媒体', null), ('6', '工具', null), ('7', '交通', null), ('8', '房地产', null), ('9', '生活服务', null), ('10', 'IT科技', null), ('11', '旅游', null), ('12', '电商', null), ('13', '医疗', null), ('14', '政务民生', null), ('15', '商家自营', null), ('16', '快递邮政', null), ('17', '体育', null), ('18', '社交', null);
COMMIT;

-- ----------------------------
--  Table structure for `app_product`
-- ----------------------------
DROP TABLE IF EXISTS `app_product`;
CREATE TABLE `app_product` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `PROD_NAME` varchar(100) DEFAULT NULL COMMENT '产品名称',
  `PROD_DESC` varchar(1024) DEFAULT NULL COMMENT '产品描述',
  `QR_CODE_ICON` varchar(1024) DEFAULT NULL COMMENT '二维码图片地址',
  `MP_CODE_ICON` varchar(1024) DEFAULT NULL,
  `PROD_ICON` varchar(1024) DEFAULT NULL COMMENT '产品ICON',
  `APP_URL` varchar(100) DEFAULT NULL COMMENT '小程序URL',
  `COLUMN_ID` varchar(11) DEFAULT NULL COMMENT '栏目ID',
  `LABELS` varchar(200) DEFAULT NULL COMMENT '标签集，以,号分割',
  `IMAGES` varchar(1000) DEFAULT NULL COMMENT '图片截图，以,号分割',
  `STATE` varchar(10) DEFAULT NULL,
  `PUBDATE` date DEFAULT NULL COMMENT '发布时间',
  `AUTHOR` varchar(20) DEFAULT NULL COMMENT '发布者',
  `USER_ID` int(11) DEFAULT NULL,
  `STAR` int(1) DEFAULT '0',
  `COMM_ACOUNT` int(11) DEFAULT '0',
  `PAGE_VIEW` int(11) DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `PROD_NAME` (`PROD_NAME`) USING BTREE,
  UNIQUE KEY `PROD_NAME_2` (`PROD_NAME`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=362 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `app_product`
-- ----------------------------
BEGIN;
INSERT INTO `app_product` VALUES ('34', '背宝', '随时随地背几个单词、背几处知识点，帮助您在不知不觉中提高成绩、增长学识。', 'qr_code_icon/1484017159354ewm.jpg', null, 'prod_icon/1484017159354icon.jpg', '', '8', null, 'images/14840171593542d70bcceeb6411d944083ec4c666bb28b95ebb9b-e3039f248dd555899a396179b51a05be377f9973.png,images/14840171593541f2d7f7532429e83da45c4fe8b1c2d589c0067e6-bd473197c461193ea9b6d317f4c236910d065887.png,images/1484017159354ba16dde6e93df301cd9a6b9316bef7e2713a33c8-278cadb5c5a600fd354bbb4a32acf34407bf98f0.png,images/14840171593549d7989e1f8300714b5911a55ab9984634747c832-5c20dcbcfbab07ab6c2df7e27444d5ac2afca569.png', '0', '2017-01-10', 'liro', null, '0', '0', '2'), ('35', '金山词霸', '金山词霸是一款快速，准确的词典翻译工具。', 'qr_code_icon/1484018258946ewm.jpg', null, 'prod_icon/1484018258946icon.jpg', '', '8', null, 'images/14840182589461.png,images/14840182589462.png,images/14840182589463.png,images/14840182589464.png', '0', '2017-01-10', '李佳龙', null, '4', '14', '83'), ('37', '词汇量测试', '简单两步准确测量你的单词量。', 'qr_code_icon/14840186208731b28ddb0ab05c306eac86a8e75fb813ab6e7dfd3-33f39dbc1f1c81f8179d0c1463efa2d47d5588d2.jpg', null, 'prod_icon/1484018620873c83c6162d5f728c36226f33622c268af2955c9b8-813823efb514307340aca9d42a11b3a57d8fcbd1.jpg', '', '8', null, 'images/14840186208735.jpg,images/14840186208736.jpg,images/14840186208737.jpg,images/14840186208738.jpg', '0', '2017-01-10', 'TJT', null, '0', '0', '0'), ('38', '校外日程表', '时间管理类工具，以日历表为主要展现形式，用于家长高效管理孩子或自己的各类日程安排。', 'qr_code_icon/1484018743828b052e258a0e1d241826dc6afa1707085e5580970-2713b40e37ff7d765d98f51f6a81a55bf2a86e59.jpg', null, 'prod_icon/1484018743828d5e8549cfc7b8f599f70d5e1beed4b51a16894a0-8bc763f035236f23db5c447f665e1e1361fe8fee.jpg', '', '8', null, 'images/14840187438281.jpg,images/14840187438282.jpg,images/14840187438283.jpg,images/14840187438284.jpg', '0', '2017-01-10', 'JackieMon', null, '0', '0', '0'), ('40', '书法字典大全', '二十万历代名家书法字，包含五种字体：篆书、隶书、楷书、行书、草书等。 学习书法，练习书法，研究书法宝典！', 'qr_code_icon/14840189126898406c178067cb0a98b5dfcf4967f66782b3a1347-9c9f9e86f69fc52d39686fede8cdcd38ee585149.jpg', null, 'prod_icon/14840189126892bc78a5029bc9e180b78c05f33cefa9769e38445-90de4c01575d01006485fea670f1afea02d6c9b1.jpg', '', '8', null, 'images/1484018912689656fdab1d26fa022e7f84e8f2de265c88464d823-6d204decd5b8b82a7c5b378a0932538fd1a1cd79.jpg,images/1484018912689e3a57272a7f04abfb6162798b65f01c2a5419de8-85bbb20607a9bcc14fe0c5a8e72993df9c15d7da.jpg', '0', '2017-01-10', '方方', null, '0', '0', '8'), ('41', '乐词斩', '新东方在线官方推出的背单词小程序，每天斩获15个单词，轻松掌握单词奥义，还有学霸模式随心斩。现有大学英语四级和六级词库。', 'qr_code_icon/1484019596620a73e2d2ffeaba6646d624e58194aa3d70fb852c9-6fcf491d6b6233f81915385033648c719e40b3fb.jpg', null, 'prod_icon/148401959662026729473f4cfa821864d547180b34a750bc43b24-5672d9395803afda405255d6524a742cfdd508b8.jpg', '', '8', null, 'images/14840195966201.jpg,images/14840195966202.jpg,images/14840195966203.jpg,images/14840195966204.jpg', '0', '2017-01-10', '小号斯密达', null, '0', '0', '0'), ('44', '启信宝商业搜索', '启信宝商业搜索 介绍\r\n启信宝是一款快速精准的企业信息查询工具，为各界人士提供丰富详尽的企业信息检索，尤其能帮助金融从业者、律师、投资人、媒体记者、销售与管理等专业、商务人士提供全面、客观、权威的工商、投资、司法拍卖、资质、许可、处罚等企业信息，是各界商务人士必备的企业征信利器。', 'qr_code_icon/1484031541981c3cd4552fd6583079862427a7294adcfa3a9595a-92359d622266b96057006b35d68a53c626c1294e.jpg', null, 'prod_icon/14840315419817be2b5095de49e78a8a4b2a9a818c034a42f5c83-81c27284f77a447375ba39fb2f0005eeaccf28d8.png', '', '', null, 'images/1484031541981f2e313aff1c73b2ef01d9dc59b51b3a71d971d68-76db2485b8c49bb20bb35f98afd31c0122f6be37.png', '0', '2017-01-10', '启信宝', '7', '0', '0', '0'), ('45', '21世纪经济报道', '21世纪经济报道 介绍\r\n21世纪经济报道汇聚全球200余名专业采编人员全天候提供的一手财经和商业新闻，并给予读者既专业又通俗的解读。', 'qr_code_icon/1484031660265c438c727232cedb048308c0566ce15c85241fc96-0908cb266206b20a1c41e98e6da3ecf990d60439.jpg', null, 'prod_icon/14840316602657e9657aeb8185a8f684d2f228a0a4d7e11ed5289-2250c76ef3e057ba1ecea12143487f47130139e2.png', '', '11', null, 'images/14840316602659ef302dc71f4e6b47dfe5eb6f5cd9262b560a11d-f4f894aa5da3ab2d957de906a8a103a38295c11b.png,images/148403166026545db1db492b2bd6e885937395baa2e0ca9394dc9-47abad63b60d5063e319384922cc54903d78e41f.png,images/1484031660265579642d6c86b601140d7842d26cb8053007d5581-37b437075988fde4d2f4a1b48884859e3b0d5e36.png', '0', '2017-01-10', '21newmedia', '7', '4', '3', '10'), ('46', '广发基智理财', '广发基智理财 介绍\r\n基智理财是广发基金推出的一项智能理财服务，通过判断投资者的投资需求，为投资者提供最优的投资组合方案，并根据市场行情及周期转换对方案进行及时调整，投资者一键跟投。智慧理财，省心省力。', 'qr_code_icon/148403181295719b1de9e69c6c366787f5f3be3f55086b49e591b-e203473ee16b37bdac47a1f2640ad313e27ebe0d.jpg', null, 'prod_icon/14840318129575bc4f6042453e300b643d8d0fb6b3a8f89658600-603cf3aefe9fe748a74fdc4a3ba526e2bbc7467d.png', '', '11', null, 'images/14840318129576f27384fca4f022f6f3abe1b554a790031d07757-e3039f248dd555899a396179b51a05be377f9973.png,images/148403181295779eae5518ee006aba7bc15037b4788df8e2e8178-5c20dcbcfbab07ab6c2df7e27444d5ac2afca569.png,images/1484031812957aa5462d360aeaefb8ed0547240403bff8883ec63-278cadb5c5a600fd354bbb4a32acf34407bf98f0.png,images/1484031812957ae20ecf43b953e8ef222af1f255244b8a393a6fd-bd473197c461193ea9b6d317f4c236910d065887.png', '0', '2017-01-10', 'Raymond', '7', '4', '3', '22'), ('47', '吴晓波频道会员', '吴晓波频道会员 介绍\r\n超10万新锐中产在此共享知识。 吴晓波频道新锐会员权益： 1、每天听见吴晓波：聆听智者的拨云见雾 2、晓课堂/晓报告：学习系统的理财职场课程，探底最前沿的商业报告； 3、同读一本书：与10万新锐中产成为同伴，抱团取暖。', 'qr_code_icon/148403196783637e18878df0f961f994b06c0cbcb6f5f797debf7-ca93e48c5efb034cfbeb6a6c7a33bcfd20f5ae08.jpg', null, 'prod_icon/1484031967836e62e591b794fc9e725c70a46484ca430e96d0bbc-accf102caaa970ce65d217b9ae9a8e9a57caa67c.jpg', '', '11', null, 'images/1484031967836a7e13a71754813290e73209220493f83cdeeb3d5-278cadb5c5a600fd354bbb4a32acf34407bf98f0.png,images/1484031967836a88e1050049fff951eaa7b7d8cd97dec3f72dde0-5c20dcbcfbab07ab6c2df7e27444d5ac2afca569.png,images/1484031967836f0aacc69f6871cdbab560913c08add12c39ba10b-bd473197c461193ea9b6d317f4c236910d065887.png', '0', '2017-01-10', '吴晓波频道', '7', '5', '2', '3'), ('48', '水滴互助应用', '水滴互助应用 介绍\r\n水滴互助是面向大病/意外的互助社群，一人患病，众人均摊。关爱自己、呵护家人，与百万会员抱团抵御健康风险。已获美团-大众点评、IDG、高榕资本等5000万元投资，徐小平、王兴等互联网大佬力荐。进入公众号点击“加入互助”了解互助计划们。', 'qr_code_icon/14840321296992cec4dac0be84b57e7abe81536d7d71b0fc69aaa-11b39ed170715803752b572e3b015b3e53256a02.png', null, 'prod_icon/148403212969941b062ee1b7138222d07ded34995c5205ac31b30-a788168553352db0b82e63f0675424993ecc78eb.png', '', '11', null, 'images/14840321296992bda31ecd2edccaedc2dfeb69552fb1e8f66ef21-f3e0a8e0b9bafa10b8c1e5ac06134890ec3a12a1.png,images/14840321296992d6a3d82df76a749fa11be9ac530af5fcfd89268-0624f15b4230566846f9760f299036e090af7af5.png,images/148403212969945e4f3d1e74f99a828bbfa02cce57022ddd3ac34-f10138784f44b1e1ad4d5747e038db2403b1aa65.png,images/1484032129699b94857590750da3a488facc43089adfdc2d8d657-0461cf088d999eb5cf70547d3c2a149ae4d26538.png', '0', '2017-01-10', '水滴互助', '7', '5', '2', '8'), ('49', '理财小算盘', '理财小算盘 介绍\r\n提供理财所需的计算器，如定投，贷款，汇率计算等。', 'qr_code_icon/1484032738460c3db6b71a4ef50f3d0175801764d1c65f49f098f-c9c12f69ed63ef54070711779da6923cf60c3f38.jpg', null, 'prod_icon/1484032738460070385d28ba980e5c1e620af75f69731dea3bd3c-bd367acb6eca77a23ecd6a88153618c0c4fcab4b.png', '', '11', null, 'images/14840327384606354d84063d5662c226368b83731113f843983d1-acc85747c97f4310ba0d4ee2a9c803c9a192e56a.png,images/1484032738460c126e81565b922f3a516c744a60e1570033a5733-eb3a8fb9db95c04c37b564a7600d89f1e24df830.png,images/1484032738460ef461d184ca95e91f947e11f22ce240f8fe395a7-73bc4108b56dab218a3e1a9bb06416543f1ab096.png,images/148403273846060dbd2ed08d3b2ce7674c59271e45808022c2ea3-b04a62425c023f6a92121d80d8ffda8401b8c5f6.png', '0', '2017-01-10', 'xinqian', '7', '5', '5', '7'), ('50', '雪球炒股', '雪球炒股 介绍\r\n1000万人在用的股票投资应用，牛人云集的投资者交流平台，每天获取无穷尽干货好贴，与真实的投资高手深入交流。', 'qr_code_icon/14840329111504b115acf065bb9c060116715cc91f264a518bad2-d6617797d18fcdc2cfb670729caf76e51d589c6c.jpg', 'mp_code_icon/1484998818953t0164de741f3fe6322b.jpg', 'prod_icon/14840329111507f6d0cf5e5a6e3ca6f99fb77decb2b1e741a25c3-511b03890967cc8e4916a5915e72776e47109fd2.png', '', '11', '6', 'images/14840329111508a7857df372c7df153a505fadab2a797cdd137e6-ebc520c6b85256b4de4348637ad46c78ff674c8b.jpg,images/14840329111500d68be957fb5c37217921b10cb21882e54075a2a-4029e18990f4caf6984200fdf1062554b3837926.jpg,images/1484032911150df366694c4d3883fb015dad5a3395cde17c9700d-bb21b1b82d5c6b33ec8f9b2a729d6c7709ce1766.jpg', '0', '2017-01-10', 'pawaca', '7', '5', '2', '3'), ('53', '通勤助手', '· 随时查看上下班的路况，为您推荐最优路线，再也不用担心时间都耽误在路上啦！ · 内急怎么办？通勤助手为你快速找到附近的厕所！舒坦！', 'qr_code_icon/14840334563132.jpg', null, 'prod_icon/14840334563131.jpg', '', '4', null, 'images/14840334563133.jpg,images/14840334563134.jpg,images/14840334563135.jpg,images/14840334563136.jpg', '0', '2017-01-10', 'Answer', '16', '0', '0', '2'), ('54', 'HacPai', '通过扫描书籍ISBN查询书籍信息，并将书籍信息发布到HacPai。', 'qr_code_icon/14840335744552.jpg', null, 'prod_icon/14840335744551.png', '', '8', null, 'images/14840335744553.png,images/14840335744554.png', '0', '2017-01-10', 'Vanessa', '16', '0', '0', '0'), ('56', '极速问医生', '付费咨询医生，门诊医生10分钟在线解答疾病问题，解读报告，指导就医，提供治疗建议。', 'qr_code_icon/14840338417242.jpg', null, 'prod_icon/14840338417241.png', '', '5', null, 'images/14840338417243.png,images/14840338417244.png,images/14840338417245.png', '0', '2017-01-10', '就医160', '16', '0', '0', '5'), ('58', '春雨医生+', '春雨医生是医患之间的实时互动交流平台。用户通过免费提问或付费指定的方式联系医生平台。身体不适问春雨，随时随地看医生。', 'qr_code_icon/14840340612892.png', 'mp_code_icon/1484998892627t01918c9c980fa6772f.jpg', 'prod_icon/14840340612891.png', '', '5', '6,13', 'images/14840340612893.png,images/14840340612894.png', '0', '2017-01-10', '春雨医生', '16', '0', '0', '0'), ('59', '华药商城', '药品、医疗器械的互联网第三方信息展示平台', 'qr_code_icon/14840341259932.jpg', 'mp_code_icon/1485060650201wxsc.png', 'prod_icon/14840341259931.png', '', '5', '13', 'images/14840341259932.png,images/14840341259933.png,images/14840341259934.png,images/14840341259935.png', '0', '2017-01-10', '华药商城', '9', '0', '0', '550'), ('60', '解忧相知', '在生活中遇到棘手的需要解决问题，可以找附近人帮助 ，发送附近任务，附近人看到可以帮助解决，这个小程序旨在让人们之间的资源达到合理的利用！', 'qr_code_icon/14840341761662.jpg', null, 'prod_icon/14840341761661.jpg', '', '23', null, 'images/14840341761663.jpg,images/14840341761664.jpg,images/14840341761665.jpg,images/14840341761666.jpg', '0', '2017-01-10', '二哼', '16', '0', '0', '0'), ('62', '摩点微打赏', '微打赏是一款社交圈的筹款工具，当你有任何筹款需求的时候，可以在相应分类下快速发起一个筹款申请，分享到社交平台获得支持，粉丝应援、爱心筹款、发布梦想。摩点微打赏，让筹款从未如此简单。', 'qr_code_icon/14840344355752.jpg', null, 'prod_icon/14840344355751.png', '', '23', null, 'images/14840344355753.png,images/14840344355754.png,images/14840344355755.png,images/14840344355756.png', '0', '2017-01-10', '摩点微打赏', '16', '0', '0', '2'), ('63', '求大夫鉴定', '什么值得买？42万医生为你把关，还有医生集体推荐的健康产品。', 'qr_code_icon/14840345455452.jpg', null, 'prod_icon/14840345455451.jpg', '', '5', null, 'images/14840345455453.jpg,images/14840345455454.jpg,images/14840345455455.jpg,images/14840345455456.jpg', '0', '2017-01-10', '杏仁', '16', '0', '0', '0'), ('64', '自选股', '自选股涵盖沪深港美全市场实时行情，推送及时的股价提醒，支持快速查询股价、分时K线及相关新闻等，为用户提供专业看盘炒股服务', 'qr_code_icon/1484034591671zxg.jpg', null, 'prod_icon/1484034591671zxgtb.png', '', '11', null, 'images/1484034591671zxg1.png,images/1484034591671zxg2.png,images/1484034591671zxg3.png', '0', '2017-01-10', '深圳市腾讯计算机系统有限公司', '8', '3', '5', '13'), ('65', '在线律师法律咨询', '天穗律师事务所免费法律咨询小程序，由专业律师免费为您解决一切法律问题。', 'qr_code_icon/14840347026721.jpg', null, 'prod_icon/14840347026722.jpg', '', '9', null, 'images/14840347026723.jpg,images/14840347026724.jpg', '0', '2017-01-10', '天穗', '16', '4', '2', '6'), ('66', '吖吖识字', '一款简洁又好用，针对1-3岁小朋友的识字卡片小程序。', 'qr_code_icon/14840348033611.jpg', null, 'prod_icon/14840348033612.jpg', '', '8', null, 'images/14840348033613.jpg,images/14840348033614.jpg,images/14840348033615.jpg', '0', '2017-01-10', '吖吖识字', '16', '0', '0', '0'), ('67', '同程旅游', '同程小程序是一款无需下载安装，只需扫描二维码即可 实现产品订购和增值服务的应用，目前开放了火车票、 飞机票、汽车票、酒店、景点等多个产品入口，并已全 部完成小程序的搭建。在不久的将来，用户在到达火车 站、机场、汽车站、景区、门店等场景时，可轻松实现 扫码购票和到场服务。 同程致力于打造不同场景的差异化服务，将对旗下产品 做出全线智慧升级，以更丰富多元的产品，依托小程序 ，领跑智慧出行。', 'qr_code_icon/1484034888675tc.jpg', 'mp_code_icon/1484998010922t01afe6f69b5a9d0c60.jpg', 'prod_icon/1484034888675tctb.jpg', '', '2', '6,11', 'images/1484034888675tc1.jpg,images/1484034888675tc2.jpg,images/1484034888675tc3.jpg', '0', '2017-01-10', '同程旅游', '8', '5', '3', '22'), ('68', '小猫存钱', '小猫存钱 介绍\r\n个人财务管理小程序，『懒人记账』快速理清个人账务。『备忘录』不担心信用卡、房贷忘还。『神奇道具』，一键看清理财真实面目。', 'qr_code_icon/1484034898144e56f0216b0b1806fd3e4467f799f056246947a98-1ddd4a434d923d3788052a7b99761a82d43d5a88.jpg', null, 'prod_icon/148403489814417d274d96d9f6a5024191f6f1b3bcc482adb5c0e-1f50826eb97557267e9bf48728c9874810833481.jpg', '', '11', null, 'images/1484034898159a8b55226a3e72f9b28aecabae3a5cd281e1210b3-335f8b0036bd286b05ad8063ea743931212388e0.jpg,images/1484034898159a98a87de5a7b8bef80ed1c5842b6410001222800-6f0f90e18930887dbf656debd928b9b7278cac58.jpg,images/1484034898159b4303d94fab7426a5549ef79d869bdaad5ffd70d-a12e5c0c4e0c322b2ccfc477aeba9db85836a62a.jpg', '0', '2017-01-10', 'inlook99', '7', '5', '2', '2'), ('69', '随手记', '随手记账，随手算账，记多人账', 'qr_code_icon/14840349430351.jpg', null, 'prod_icon/14840349430352.png', '', '7', null, 'images/14840349430513.jpg,images/14840349430514.jpg,images/14840349430515.png', '0', '2017-01-10', '罗小二', '16', '5', '1', '14'), ('70', '去哪儿出行', '“去哪儿旅行”的双胞胎弟弟“去哪儿出行”，光速抢票，极速出票，免登录，可预约，2步预订飞机，火车，汽车，各种票。回家买票的路上不再孤单，去哪儿出行为您保驾护航。 小程序二维码不支持在微信中长按识别，只能通过微信扫一扫才能打开。Android 版微信支持将小程序添加至桌面。而 iOS 版微信仅支持将小程序置顶于聊天界面，用户在聊天界面至多置顶一个小程序。', 'qr_code_icon/1484035002661qnr.png', null, 'prod_icon/1484035002661tnrtb.jpg', '', '2', null, 'images/1484035002661tnr1.jpg', '0', '2017-01-10', '去哪儿网', '8', '5', '5', '22'), ('72', '携程', '携程旅行网小程序，提供酒店、机票、火车票、汽车票、门票预订服务。', 'qr_code_icon/1484035138162xc.png', null, 'prod_icon/1484035138162xctb.png', '', '2', null, 'images/1484035138162xc1.jpg,images/1484035138162xc2.jpg,images/1484035138162xc3.jpg,images/1484035138162xc4.jpg', '0', '2017-01-10', 'ctrip', '8', '4', '6', '15'), ('73', '班田互动', '班田互动(BRANDSH)拥有8年数字营销与网站设计开发经验，已为100余位国际与本地客户提供数字营销服务。', 'qr_code_icon/14840351868041.png', null, 'prod_icon/14840351868042.jpg', '', '8', null, 'images/14840351868043.jpg,images/14840351868044.jpg,images/14840351868045.jpg,images/14840351868046.jpg', '0', '2017-01-10', '班田互动', '16', '0', '0', '0'), ('74', '轻烟Lite', '轻烟是独树一帜的互联网健康吸烟管理小程序。', 'qr_code_icon/14840352884141.jpg', null, 'prod_icon/14840352884142.jpg', '', '7', null, 'images/14840352884143.png,images/14840352884144.png,images/14840352884145.png', '0', '2017-01-10', 'Neco.W', '16', '0', '0', '5'), ('75', '广州妇儿中心+', '提供患者移动服务与支付，包括导诊挂号、费用支付、报告查看、就诊指引、就医反馈等全流程闭环服务', 'qr_code_icon/14840353461811.jpg', null, 'prod_icon/14840353461812.png', '', '5', null, 'images/14840353461813.jpg', '0', '2017-01-10', '人在天涯', '16', '0', '0', '1'), ('76', '趣住啊', '趣住啊－一个有趣的海外民宿预定及社交平台 趣住啊，由具有互联网背景的自由行玩家踏遍全球美景后，热血而造 趣住啊，不断丰富平台上的全球民宿，最自由的出行方式 搭建您与民宿主人最直接的沟通桥梁，感受世间的风土人情，让旅行更有深度 趣住啊特色功能 －为您精选海外民宿，体验最当地的人情之旅 －直接联系房东，沟通无障碍 －当地人合作管理模式，保证民宿品质，让您安心入住 －支持支付宝和微信支付，趣住啊－一个有趣的海外民宿预定及社交平台 趣住啊，由具有互联网背景的自由行玩家踏遍全球美景后，热血而造 趣住啊，不断丰富平台上的全球民宿，最自由的出行方式 搭建您与民宿主人最直接的沟通桥梁，感受世间的风土人情，让旅行更有深度 趣住啊特色功能 －为您精选海外民宿，体验最当地的人情之旅 －直接联系房东，沟通无障碍 －当地人合作管理模式，保证民宿品质，让您安心入住 －支持支付宝和微信支付，人民币结算，预订快捷方便 趣住啊，趣住进世界。 请关注我们 官方网站：www.bnbtrip.com 新浪微博：趣住啊 微信公众号：趣住啊', 'qr_code_icon/1484035375353qza.jpg', null, 'prod_icon/1484035375353qzatb.png', '', '2', null, 'images/1484035375353qza1.png,images/1484035375353qza2.png,images/1484035375353qza3.png,images/1484035375353qza4.jpg', '0', '2017-01-10', '趣住啊', '8', '5', '2', '4'), ('77', '劳动法计算器', '劳动法计算器 介绍\r\n劳动法计算器是中国劳动法推出的法律智能应用。根据用户输入的条件计算法定经济补偿金、个税、年终奖所得税、法定年休假、工伤待遇等项目，并给出计算依据提示。已收录城市计算口径已经经过数万次计算验证。', 'qr_code_icon/1484035400556802eeb37b4a756909fbef469b6f6d1c84d78582c-71c5ec571ff8ade2d15493f459c474a72cae3bec.jpg', null, 'prod_icon/1484035400556dd9c602274c6a642710313693441ad60de8d874f-ff89d79ec7c08da9b2f2c9987c44e260c0a07f45.jpg', '', '11', null, 'images/14840354005565d3cd330f7cb681f568c509f38acc7251004a16b-278cadb5c5a600fd354bbb4a32acf34407bf98f0.png,images/1484035400556a338f67c0495f0e5040324e0eb26db5d36543355-5c20dcbcfbab07ab6c2df7e27444d5ac2afca569.png,images/14840354005560d4109adf5dfbaab6a84b2655c3320cd823d9473-e3039f248dd555899a396179b51a05be377f9973.png,images/1484035400556abc941e979f82eb2ea6e840f82396334c2a85b90-bd473197c461193ea9b6d317f4c236910d065887.png', '0', '2017-01-10', 'domon', '7', '5', '1', '5'), ('78', '丁香医生+', '丁香医生小程序，搜索和发现可靠的医疗信息，远离朋友圈谣言。', 'qr_code_icon/14840354246821.jpg', null, 'prod_icon/14840354246822.jpg', '', '5', null, 'images/14840354246823.png,images/14840354246824.png,images/14840354246825.png', '0', '2017-01-10', 'minichaser', '16', '0', '0', '0'), ('80', '航旅纵横', '中国民航信息官方打造的权威民航服务，查航班动态，手机选座，轻松搞定，出行必备', 'qr_code_icon/1484035524339hl.jpg', null, 'prod_icon/1484035524339hltb.png', '', '2', null, 'images/1484035524339hl1.png,images/1484035524339hl2.png,images/1484035524339hl3.png,images/1484035524339hl4.png', '0', '2017-01-10', '航旅纵横', '8', '0', '0', '3'), ('81', '今日汇率', '今日汇率 介绍\r\n【今日汇率】超级方便稳定的汇率查询换算工具，YAHOO金融数据同步，真的很方便', 'qr_code_icon/14840355418087327750c107a5e2f3a2c1d52240c199d3b0801ad-f4d5f9a87734aeb48e53d2f4b3afb955cdbf43ae.jpg', null, 'prod_icon/1484035541808d59fc54cbf67a318b455fea87e49418ad409d3c1-1f50826eb97557267e9bf48728c9874810833481.jpg', '', '11', null, 'images/1484035541808b9ef047846a7dc035fe4f9952701f57b85facfd2-c7c2d6650fe8dd3125b1541cb39af56649bd56fa.jpg,images/148403554180869d9bdf0bc635d5b4353aa834c9a718c11189024-accf102caaa970ce65d217b9ae9a8e9a57caa67c.jpg,images/1484035541808116a595b66bd1b5e5afabe54c5e59871667cac97-6896a8696b8038f4fc8989ab005e4fccc3b90047.jpg', '0', '2017-01-10', 'Soup', '7', '5', '2', '3'), ('82', '房贷计算器专业版', '最专业的免费房贷税费计算神器！ 房贷：商贷 公积金贷款 组合贷，每月还款 支付利息一目了然 税费：新房 二手房都能准确计算', 'qr_code_icon/14840356847011.jpg', null, 'prod_icon/14840356847162.png', '', '9', null, 'images/14840356847163.png,images/14840356847164.png,images/14840356847165.png,images/14840356847166.png', '0', '2017-01-10', '房贷计算器专业版', '16', '4', '2', '6'), ('83', '100房贷助手', '准备贷款，想知道能承受多高的额度，月供多少。 已经贷款，央行宣布利息下/上调xx点，想知道月供会如何变化。 提前还款，想知道能缩短多少期限，节约多少利息。 用100房贷助手，让一切简单！', 'qr_code_icon/14840357699521.jpg', null, 'prod_icon/14840357699522.png', '', '7', null, 'images/14840357699523.jpg,images/14840357699524.jpg,images/14840357699525.jpg,images/14840357699526.jpg', '0', '2017-01-10', 'DoubleCai', '16', '4', '2', '9'), ('84', '高端酒店特价', '高端酒店特价是针对城市白领在休闲度假场景下便捷地找到又好又划算的高端度假酒店的小程序，由上海尚旅网络科技有限公司出品。', 'qr_code_icon/1484035793124jd.png', null, 'prod_icon/1484035793124jdtb.png', '', '2', null, 'images/1484035793124jd1.jpg,images/1484035793124jd3.jpg,images/1484035793124jd4.jpg', '0', '2017-01-10', '尚旅', '8', '5', '2', '4'), ('85', '贴现助手', '覆盖全部票据种类，实时呈现票据市场行情走势，显示最高最低价格。票据贴现利率计算器，年息月息自动转换，一键得出贴现利息。', 'qr_code_icon/14840358311241.jpg', null, 'prod_icon/14840358311242.jpg', '', '7', null, 'images/14840358311243.jpg,images/14840358311244.jpg', '0', '2017-01-10', '都顺', '16', '0', '0', '0'), ('86', '股票灯塔', '股票灯塔是一款全新的人工智能大数据炒股工具。灯塔表哥7X24小时智能问股诊股、大数据选股；更有筹码分布、相似K线、历史回看、个股直播等大数据分析工具。灯塔让股市变得从未如此清晰，让炒股变的从未如此轻松。', 'qr_code_icon/14840359159541.jpg', null, 'prod_icon/14840359159542.png', '', '11', null, 'images/14840359159543.jpg,images/14840359159544.jpg,images/14840359159545.jpg,images/14840359159546.jpg', '0', '2017-01-10', '灯塔财经', '16', '5', '2', '7'), ('87', '记账e', '日常收支记账，花销、开支分类记录，理财小帮手', 'qr_code_icon/14840359705321.jpg', null, 'prod_icon/14840359705322.png', '', '11', null, 'images/14840359705323.png,images/14840359705324.png', '0', '2017-01-10', '邓仔', '16', '4', '2', '4'), ('88', '刷卡优惠', '刷卡优惠 介绍\r\n为你私人订制的刷卡优惠信息，最优惠的信用卡还款方式！省呗还可以帮你垫付信用卡还款，用省呗还信用卡，利率仅是银行最低还款利率的六折。如果你还在为每月的信用卡账单而烦恼、为每月只能偿还信用卡的最低还款而支付大额利息心痛不已，省呗也许是你正在寻找的，我们可以帮你改变这些窘境。', 'qr_code_icon/1484035980048e06fda3616029f2b83b8e21cf9af3af265f96eb6-98c81783235250a6af1a10dea060661ec9896db0.png', null, 'prod_icon/14840359800483b6665c90b730876b467d63724dbcec83e1aa6d9-2b581b870c372017e662f3861ca07289b19be5fa.jpg', '', '11', null, 'images/14840359800483f1d6588eff40fdc3f0bf5dbc5a7915b2a71d6ba-00eea790b632cc95a3d8a52d5c013d33f2bbfeb4.jpg,images/148403598004826395a1ccf387ca9da191b9dba1c09fe62bbbda0-6fc541e6a093bec408cd5e4d4ae1f1ba0f03dc55.jpg,images/1484035980048baca5121b0c509cf61bd53778220a6972d973a6d-48ff4158dfa1d9ae82467d2e4cf6cbea3ea5a471.jpg,images/1484035980048eab2783279243d2d91657ca05cbb753d94b4b86e-78e62e932ce88fa79bf078aeb263383865f2c23b.jpg', '0', '2017-01-10', '省呗', '7', '3', '2', '3'), ('89', '奇遇旅行', '海外吃喝玩乐行专家。致力于深耕目的地，帮助用户搜罗境外旅行目的地好吃、好喝、好玩、好去处，提供私人定制和即时预订服务。 用户反馈： 微信客服号：qiyuxiaomishu； 邮箱：service@fantastrip.cn', 'qr_code_icon/1484036011205qy.jpg', null, 'prod_icon/1484036011205qytb.png', '', '2', null, 'images/1484036011205qy1.png,images/1484036011205qy2.png,images/1484036011205qy4.png', '0', '2017-01-10', '奇遇旅行', '8', '0', '0', '0'), ('90', '贷款e', '各类贷款平台评测及贷款申请、信息服务', 'qr_code_icon/14840360441431.jpg', null, 'prod_icon/14840360441432.jpg', '', '11', null, 'images/14840360441433.png,images/14840360441434.png', '0', '2017-01-10', '邓仔', '16', '4', '2', '9'), ('92', '汇率e', '汇率查询及相关服务', 'qr_code_icon/14840361676441.jpg', null, 'prod_icon/14840361676442.png', '', '9', null, 'images/14840361676443.png,images/14840361676444.png', '0', '2017-01-10', '邓仔', '16', '0', '0', '0'), ('93', '朋友家精选民宿', '朋友家是一个精选美宿预订平台，不论旅行还是轰趴聚会，都可以在这里轻松预订到精美的短租民宿客栈公寓。', 'qr_code_icon/1484036171426pyj.jpg', null, 'prod_icon/1484036171426pyjtb.jpg', '', '2', null, 'images/1484036171426pyj1.png,images/1484036171426pyj2.png,images/1484036171426pyj3.png,images/1484036171426pyj4.png', '0', '2017-01-10', 'friendshome', '8', '0', '0', '0'), ('94', '最新汇率查询', '汇率、汇率查询、最新汇率信息、出国旅游、国外旅行汇率计算、人民币兑美元、人民币兑日元、韩元、英镑', 'qr_code_icon/14840362514741.jpg', null, 'prod_icon/14840362514742.jpg', '', '9', null, 'images/14840362514743.jpg,images/14840362514744.jpg,images/14840362514745.jpg,images/14840362514746.jpg', '0', '2017-01-10', '优速尔科技', '16', '0', '0', '0'), ('95', '新股申购宝', '新股申购信息发布平台', 'qr_code_icon/14840363487251.jpg', null, 'prod_icon/14840363487252.png', '', '11', null, 'images/14840363487253.png,images/14840363487254.jpg', '0', '2017-01-10', '小谷子', '16', '4', '2', '3'), ('96', '就旅行', '就旅行官方小程序，提供国内机票、特价机票预订，90后旅行购票预订平台。', 'qr_code_icon/1484036466836jlx.jpg', null, 'prod_icon/1484036466836jlx.png', '', '2', null, 'images/1484036466836jlx1.png,images/1484036466836jlx2.png,images/1484036466836jlx3.png', '0', '2017-01-10', 'jiulvxing', '8', '0', '0', '1'), ('97', '小小房贷计算器', '一款计算房屋贷款的小工具，让房贷计算一目了然。 支持：商业贷款、公积金贷款、组合贷款等，更有相关攻略等你来。', 'qr_code_icon/14840364733511.jpg', null, 'prod_icon/14840364733512.jpg', '', '7', null, 'images/14840364733513.png,images/14840364733514.png,images/14840364733515.png,images/14840364733516.png', '0', '2017-01-10', 'TmT团队@腾讯微信', '16', '0', '0', '7'), ('99', '德州扑克工具', '中国最大的德州扑克工具平台。包括 ①盈亏记录 ②胜率计算 ③保险计算 ④德州财神 ⑤活动神器。更多工具持续更新中。', 'qr_code_icon/14840366432601.jpg', null, 'prod_icon/14840366432602.jpg', '', '19', null, 'images/14840366432603.png,images/14840366432604.png', '0', '2017-01-10', '德州扑克工具', '16', '0', '0', '4'), ('101', '企微·快销上报', '1、门店销售上报，结合定位与图片上传；2、方便业务员扫码上报数据，简化录入流程；3、销售数据及时反馈，及时了解市场变化', 'qr_code_icon/14840367514021.jpg', null, 'prod_icon/14840367514022.jpg', '', '7', null, 'images/14840367514023.jpg,images/14840367514024.jpg,images/14840367514025.jpg', '0', '2017-01-10', '企微', '16', '0', '0', '0'), ('102', '汇率换算助手', '查汇率用汇率换算助手，出国留学移民旅游必备工具，支持全球一百多个国家和地区的即时汇率精确换算，是不可多得的贴心管家。', 'qr_code_icon/14840368400591.jpg', null, 'prod_icon/14840368400592.png', '', '7', null, 'images/14840368400593.png,images/14840368400594.png', '0', '2017-01-10', '滴答网', '16', '0', '0', '0'), ('103', '百姓MINI', '百姓MINI 介绍\r\n家政、找工作、二手家电、车辆、房产等，快速查询，优质生活信息一手掌握。', 'qr_code_icon/1484036887982cff0da78b606c36123a7cbd3c8de7ba0eaf21393-d8740f8f4240151443fbd2c31580147e65702c98.jpg', null, 'prod_icon/1484036887982c72f96f2bbf2233557f1d7c9561cd1d1d5db6e1a-a2aa655225fa249e0c09ba4058bd4b4ff0a374ae.jpg', '', '11', null, 'images/148403688798216361db8563ba2c74ca929b36b9836c096e4e908-47807156680c07aa355933faa3fa03fc56585cfb.png,images/1484036887982289897fe4986474da18c03604783758235224ccc-6246e55c3f7916c4d7891903925670d245eec335.png,images/1484036887982289897fe4986474da18c03604783758235224ccc-6246e55c3f7916c4d7891903925670d245eec335.png,images/1484036887982118a3fc09c8811a434276a3917d0306023fc5cff-23592914ef25c6d4477d26e80cdcc726d680e9d4.png', '0', '2017-01-10', '百姓网', '7', '3', '2', '4'), ('104', '蘑菇街', '做你的专属时尚搭配师，打造时尚朋友圈。红人博主自拍照随时与你分享，教你如何穿衣搭配，让大众点评你的fashionstyle！', 'qr_code_icon/1484036917232mgj.jpg', null, 'prod_icon/1484036917232mgjtb.png', '', '3', null, 'images/1484036917232mgj1.png,images/1484036917232mgj2.png,images/1484036917232mgj3.png,images/1484036917232mgj4.png', '0', '2017-01-10', '蘑菇街', '8', '0', '0', '9'), ('105', '简法工具之融资计算器', '换算公司融资前后股东和投资人的注册资本、股比、估值，生成股权结构图', 'qr_code_icon/14840369235451.jpg', null, 'prod_icon/14840369235452.jpg', '', '11', null, 'images/14840369235454.jpg,images/1484036923545be63e0faaebb2d92232bd63cb85204b0217a4914-accf102caaa970ce65d217b9ae9a8e9a57caa67c.jpg', '0', '2017-01-10', '简法帮', '16', '4', '2', '2'), ('106', '优品股票通', '股价预测看未来，策略选股定乾坤。优品股票通，你的股海指南针！', 'qr_code_icon/14840370229381.jpg', null, 'prod_icon/14840370229382.png', '', '12', null, 'images/14840370229383.png,images/14840370229384.png,images/14840370229385.png,images/14840370229386.png', '0', '2017-01-10', '张峻峰', '16', '0', '0', '1'), ('107', '汽车报价查询', '汽车报价查询 介绍\r\n囊括易车网近1万款车型信息，全国2万家合作经销商，每天更新10万条汽车报价，为您提供看车、选车、买车、养车等与汽车相关的全面服务', 'qr_code_icon/14840370241889b16e094e2767a5e5b8cad958c2828fd24b034a4-c98530ca43c1355d76c13e8f9055bcd30297e713.png', null, 'prod_icon/148403702418832708dfc9f5889a812c077dfbe72c4de926673b4-676f449e9bed57cdf551f69b9ca1813766d8243a.png', '', '11', null, 'images/1484037024188328723a69a33b9905911e395ccafde24ea1542ef-bd473197c461193ea9b6d317f4c236910d065887.png,images/14840370241883e45e30cc838353187bb127db462bfab5a354ef1-278cadb5c5a600fd354bbb4a32acf34407bf98f0.png,images/1484037024188f33d2e50b37d341ae7e0e6941f8f0edb0206a686-ee673444daa2c4c150863fb4fe2e59385df85324.png,images/1484037024188fbf0e82606d3b86625b80adbc42f3953e7109416-5c20dcbcfbab07ab6c2df7e27444d5ac2afca569.png', '0', '2017-01-10', '汽车报价查询', '7', '5', '2', '3'), ('108', 'X分子商城', '所见即所买，全球最全的正品时尚潮流单品一键购买。700+优质品牌库，发现你爱的，和你即将爱上的品牌。', 'qr_code_icon/1484037060001xer.jpg', null, 'prod_icon/1484037060001xer.png', '', '3', null, 'images/1484037060001xer1.png,images/1484037060001xer2.png,images/1484037060017xer3.png,images/1484037060017xer4.png', '0', '2017-01-10', 'xer', '8', '0', '0', '0'), ('109', '货币汇率', '在线货币查询转换工具，支持全世界多个国家最新外汇汇率查询、在线货币转换', 'qr_code_icon/14840370932681.jpg', null, 'prod_icon/14840370932682.jpg', '', '7', null, 'images/14840370932683.jpg,images/14840370932684.jpg,images/14840370932685.jpg', '0', '2017-01-10', 'szdufeng', '16', '0', '0', '0'), ('111', '新三板股票查询', '最火的新三板股票查询小程序，刷股价，查定增，找股东，读财报，想怎么查，就怎么查！', 'qr_code_icon/14840371741761.png', null, 'prod_icon/14840371741762.png', '', '9', null, 'images/14840371741763.jpg,images/14840371741764.jpg,images/14840371741765.jpg,images/14840371741766.jpg', '0', '2017-01-10', '神股票', '16', '0', '0', '2'), ('112', '值得买京东优选', '什么值得买京东优选:推荐京东商城最值得买的商品。 1.优选:值得买小编精心挑选最值商品 2.发现:更多值友爆料商品，还能分类筛选', 'qr_code_icon/1484037188739jd.jpg', null, 'prod_icon/1484037188755jd.png', '', '3', null, 'images/1484037188755jd1.png,images/1484037188755jd2.png,images/1484037188755jd3.png,images/1484037188755jd4.png', '0', '2017-01-10', '什么值得买', '8', '0', '0', '4'), ('115', '快礼', '礼物说快礼，1 分钟送达的惊喜', 'qr_code_icon/1484037384682lw.jpg', null, 'prod_icon/1484037384682lwtb.jpg', '', '3', null, 'images/1484037384682lw1.png,images/1484037384682lw2.png', '0', '2017-01-10', '礼物说', '8', '0', '0', '2'), ('116', '汇率换算专业版', '汇率换算专业版 介绍\r\n新浪财经专业出品：支持全球币种的汇率换算，提供主流银行的实时牌价信息，实现各银行间的比价功能，告诉您哪些银行买卖最划算。 使用方法（更新微信至最新版本后）： 1. 点击底部“发现”页签，点击“小程序”，搜索“汇率换算专业版” 2. 使用PC打开此页面，扫描二维码访问（因微信限制，长按识别二维码无效）', 'qr_code_icon/148403740357368a4b489efd08de8d775e009db2d110e1d8a39af-8c17f22ac5c1962c3f082cd0aaba0e9416f74827.png', null, 'prod_icon/14840374035731696cddef0590fcbbd5ca5942bf72af675ce1316-64544a2d39061338a54807994dffae2cc5eda73f.png', '', '11', null, 'images/14840374035731d05d967189255823438d72634daf9f0970e9c59-917330b83150fa0d10d21b8fb34a397baf2bf982.png,images/14840374035730cfc061775b343db7ee26de86ed47ba457161b5b-308e495480c5cc97bb8f3e4aa3928d3a470a76ea.png,images/1484037403573d0dee56a92964ecca31f5accb1a3b878123c667e-2e0a029a470e5b35e257f4039f735829065e32ce.png,images/1484037403573c2dc093ad4a65db51b00d394106cacb23a3a2b6e-0cb38401b568bfb7feb94d2bf923af9741d6806e.jpg', '0', '2017-01-10', '新浪财经', '7', '4', '2', '6'), ('117', '分期计算器', '银行信用卡账单分期还款计算器', 'qr_code_icon/14840375471231.jpg', null, 'prod_icon/14840375471232.png', '', '7', null, 'images/14840375471233.jpg', '0', '2017-01-10', '咪能', '16', '0', '0', '0'), ('118', '疯牛解套', '疯牛解套小程序专为解套而生，根据个股的基本面、资金流向、技术形态、利好利空消息等因素提供个性化的专业解套方案，解套从此不求人！', 'qr_code_icon/14840376342041.png', null, 'prod_icon/14840376342042.png', '', '11', null, 'images/14840376342043.jpg,images/14840376342044.jpg,images/14840376342045.jpg,images/14840376342046.jpg', '0', '2017-01-10', 'leoren', '16', '4', '2', '6'), ('119', '美的官方商城', '小程序美的唯一官方商城； 美的全品类家电，空调、冰箱、洗衣机、电饭煲一应俱全； 专享优惠券，优惠多多，会员福利多多~', 'qr_code_icon/1484037812739md.jpg', null, 'prod_icon/1484037812739mdtb.jpg', '', '3', null, 'images/1484037812739md1.png,images/1484037812739md2.png,images/1484037812739md3.png,images/1484037812739md4.png', '0', '2017-01-10', '美的电商', '8', '0', '0', '0'), ('120', 'XMBABY喜梦宝贝', '专业青少年儿童家居用品，儿童家具，生活用品品牌。', 'qr_code_icon/1484038367066xm.jpg', null, 'prod_icon/1484038367066xmtb.jpg', '', '3', null, 'images/1484038367066xm1.png,images/1484038367066xm2.png,images/1484038367066xm3.png,images/1484038367066xm4.png', '0', '2017-01-10', 'e宝贝家纺', '8', '0', '0', '0'), ('121', '巴爷供销社', '巴爷商城的微信小应用版本，源代码开源', 'qr_code_icon/1484038480835by.jpg', null, 'prod_icon/1484038480835bytb.png', '', '3', null, 'images/1484038480835by1.png,images/1484038480835by2.png,images/1484038480835by3.png', '0', '2017-01-10', ' 巴爷', '8', '0', '0', '4'), ('122', '二手车e', '二手车信息、资讯、评估、在线查询服务', 'qr_code_icon/1484038597916es.jpg', null, 'prod_icon/1484038597916estb.jpg', '', '3', null, 'images/1484038597916es1.png,images/1484038597916es2.png', '0', '2017-01-10', '邓仔', '8', '0', '0', '0'), ('123', 'Coolbuy玩物志', '玩物志小电商平台', 'qr_code_icon/1484038759342wwz.jpg', null, 'prod_icon/1484038759357wwztb.png', '', '3', null, 'images/1484038759357wwz1.png,images/1484038759357wwz2.png,images/1484038759357wwz3.png,images/1484038759357wwz4.png', '0', '2017-01-10', 'Coolbuy', '8', '0', '0', '3'), ('124', '开眼壁纸', '设计师精挑细选的海量高清高品质壁纸，涵盖风景、运动、旅行等多种分类，让你大开眼界。', 'qr_code_icon/1484039206635ky.jpg', null, 'prod_icon/1484039206635kytb.png', '', '6', null, 'images/1484039206635ky1.jpg,images/1484039206635ky2.jpg,images/1484039206635ky3.jpg,images/1484039206635ky4.jpg', '0', '2017-01-10', 'Eyepetizer', '8', '0', '0', '2'), ('128', '蓝轨迹语言微课堂', '蓝轨迹微课堂以短小录播课程的形式，按知识点和主题分类，学习者可选择学习痛点部分，按需针对学习，达到“快准精”的学习效果。', 'qr_code_icon/1484040550856f52afaf40e899d0bac92b63757a8355c44c63dc2-0f8a035bebec6e3be65b263ff1020f68e7c219b9.jpg', null, 'prod_icon/1484040550856d707ae6dc04ac3ccc1e8f456be218e1339eeb65e-1f50826eb97557267e9bf48728c9874810833481.jpg', '', '8', null, 'images/148404055085607cadbcf57692cef3b372cbed2e05a62261ae9ce-bfbe68bcfe4a5b75cefb0afb291f724a0f84b1a0.png,images/1484040550856ba6df1539ff23e12f0bf557b14103ebf88c07f69-9333eb5f59a420d6c5a84be5f883b3c7cf2d65fb.png,images/148404055085675b950033786e8bf7223561ba5c7a590b84782d7-f6e3297bf1cfa7bb5d6f667c1b7d6cf7686cafea.png,images/1484040550856f270809f897588a63ff916d0146bbadf74d1c5ba-03024dfd9f7c294dc62ad730487c80768cb0d4a0.png', '0', '2017-01-10', '蓝轨迹教育', '10', '0', '0', '0'), ('129', '书法字帖大全', '历代名家书法碑帖大全，练字临帖必备！', 'qr_code_icon/1484040669545eb1dbf3e48341553b7ea500ca843a401e0aeaead-1b0959d0eb81f91a5150c4daf46e525bb51869bf.jpg', null, 'prod_icon/148420767627911111111111.jpg', '', '8', '4,6', 'images/14840406696391.jpg,images/14840406696392.jpg,images/14840406696393.jpg', '0', '2017-01-10', '方里格', '19', '0', '0', '0'), ('130', '英语翻译查词', '免费英语在线翻译，中英互译，学英语好帮手。可以查英语单词音标、发音、解释和例句，可以翻译整句和整段内容。', 'qr_code_icon/1484042654383977200611bfdeb7987717059b347d3af7d5e5531-cca0371c3f047f1b7d9ecbcfc6584a26ed3366e0.jpg', null, 'prod_icon/148404265438367c20bcbab065cbd4a662f6753fb4bafcbe33562-c47b56db2b10869632b1bd64e817a83fffa25998.png', '', '8', '4,6', 'images/14840426543831.png,images/14840426543832.png,images/14840426543833.png,images/14840426543834.png', '0', '2017-01-10', 'guoyaxin895', '19', '0', '0', '1'), ('132', '宝宝时光屋', '宝宝时光屋-父母记录宝贝成长的私密空间。快速记录：拿起手机即拍即传。存储安全：不限量同步保存，永不丢失。最受欢迎的宝宝智能云空间，妈妈必备的照片整理神器，全家分享的宝宝成长全纪录，最美晒娃日记小程序！', 'qr_code_icon/1484046096437904e7a67237cd6eefbf24d3bb423cf17eac44cf1-c470c10aa081c90a3b7696f4487800e6b005aa6a.jpg', null, 'prod_icon/148404609645286e5cacfdcc7be8265576f9a3eb52f9ccbc0a32f-d181ad4208e06afb63d5e6049a40521b458da19d.png', '', '8', '4,6,9,11,18', 'images/14840460964521.png,images/14840460964522.png,images/14840460964523.png,images/14840460964524.png', '0', '2017-01-10', '麦小猴子', '19', '0', '0', '2'), ('133', '青蜻蜓', '听广播电台，有声小说，相声小品，新闻，音乐，脱口秀，历史，军事就用蜻蜓FM！ 你想听的我们都有，两亿用户都在用！', 'qr_code_icon/14840997655978e451f157f4322c6febab8e83d58d78011bef20a-2bac9032570ab7bc5c6b6d338ab14ec0ca37d009.jpg', null, 'prod_icon/148409976559731e3e9f1b659c548985b6125071a4de04a726cab-d181ad4208e06afb63d5e6049a40521b458da19d.png', '', '21', '4,5,6,9,18', 'images/14840997655971.png,images/14840997655972.png,images/14840997655973.png,images/14840997655974.png', '0', '2017-01-11', 'QingTing.FM', '19', '0', '0', '0'), ('134', '美甲帮找图', '千万美甲款式图片合集，轻松选款。通过视频教程，还可以学做DIY美甲哦～', 'qr_code_icon/14841013646649dcd756c4af79d6fc5dbd0e72e0da1ca7694f7aa-c3293e678a9f7d4cdfb21f798e18889cd07d0598.jpg', null, 'prod_icon/148410136466405e58fe9f2878397a69deed498eb6ac41026d80f-cc74a0d60ef8248a9a8a4835ff1ef336471d962d.png', '', '8', '4,5,6,9', 'images/148420846046821.png,images/148420846048422.png,images/148420846048423.png,images/148420846048424.png', '0', '2017-01-11', '美甲帮', '19', '0', '0', '0'), ('135', '网易有道词典', '网易有道词典支持中英日韩法德葡俄等多语种翻译，是中国最受欢迎的免费全能翻译工具，数据权威，发音地道，工作学习旅游必备。', 'qr_code_icon/1484101669621fc860271c7a9b4d3bc32a06cdddc101e1ec6779f-f06cc104ae00a196ca0c56c836fc9d7d26c5020b.jpg', null, 'prod_icon/1484101669652155ca648abdb7341a6535e10be4b7639cb02f8f6-c59abbb176fcd6b62d01b814ee623195cf30e3cb.png', '', '8', '4,6', 'images/148420855681531.jpg,images/148420855681532.png,images/148420855681533.png,images/148420855681534.png', '0', '2017-01-11', 'Wenlong', '19', '5', '3', '12'), ('136', '得到社群', '微信小程序学习社群', 'qr_code_icon/148410195404673427349f4e80b3b21927ea138173bada2e1b0ad-6c79279fe92b65d406293afc284814e832c95cc6.png', null, 'prod_icon/1484101954046ee3dddfd0343878efdd3464a4226f8af0f446b0a-6ca0596fcc1f2e1145ad200c60e189107528ae70.png', '', '8', '4,10,18', 'images/148420863736541.png,images/148420863736542.png,images/148420863736543.png', '0', '2017-01-11', '刘焱旺', '19', '0', '0', '0'), ('137', '句逗', '句逗-与喜欢的句子不期而遇 这里只有句子，严肃的句子，励志的句子，唯美的句子，心动的句子，伤感的句子，愿你每天能遇到一句让你赏心的话，一幅悦目的图，更愿你因此天天有个好心情。', 'qr_code_icon/148410211370549ffa18fcc6cfc371f81ea8d958a02555532b3ef-a1fb6f9f8463edcc1e546d32f53c5093326469b8.jpg', null, 'prod_icon/14841021137055ac6c55a8700bd245ffa6987eb13b2d38f20167c-4b843aee4c7ef6dc1601c07fc2722d27c067d39a.png', '', '8', '3,4,5,6,18', 'images/148420872708845.jpg,images/148420872708846.png', '0', '2017-01-11', 'caicheng', '19', '0', '0', '0'), ('138', '闪电健身Mini', '适合你的锻炼才会有效果。闪电健身，你不用成为专家，一样可以练出好身材', 'qr_code_icon/1484102280613b63cb296745dde094657ca60d6c6e40cfb805b36-a2b1d57cc51548115a61c97726f77778b4c13f22.jpg', null, 'prod_icon/1484102280613e6992f030fd32ceb4b7fa00bbce6bae7f15652f1-048c1f8cbaa167942777fae9a9886e715ce1aa0e.png', '', '17', '4,6,17', 'images/148420884842061.jpg,images/148420884842062.jpg,images/148420884842063.jpg,images/148420884842064.jpg', '0', '2017-01-11', 'Nevercare♊', '19', '0', '0', '5'), ('139', '有钱兔择校', '提供择校活动信息查询功能，供家长择校使用。', 'qr_code_icon/148410266949521177f976a53a528c303be4043d7236548ac4469-ee2303a7ffedb1e926d658f2ac4136c70c4af678.png', null, 'prod_icon/1484102669495e7d6c290c9331b5f6f21c8e844c3d3932a6dcbe9-ec72cbc570d098b7987cdff4132b998d722443f0.png', '', '8', '4,5,6', 'images/148420890950171.jpg,images/148420890951672.jpg,images/148420890951673.jpg', '0', '2017-01-11', '有钱兔', '19', '0', '0', '0'), ('140', '驾考帮手', '为您提供科目一,科目四的测试题练习，以及全真模拟,助您轻松拿到驾照,考驾照,就用驾考帮手。', 'qr_code_icon/148410284153111d85e3237faff1dbb855a0e0bf0d37f5aa6582e-2641a3bd7daf4704ef221a25caac1af36568a02f.jpg', null, 'prod_icon/148410284153152b545a86562f27f36540d42c802856bfc012b3a-544d0adf38e6b555f7dc96d94fc598548328c981.jpg', '', '8', '4,6,9', 'images/148420899181775.png,images/148420899181776.jpg,images/148420899183277.jpg', '0', '2017-01-11', '长沙小雨网络科技', '19', '0', '0', '2'), ('141', '十点课堂程序', '十点课堂，给你一个不逃课的理由。大咖达人教你乐享生活、玩转职场。', 'qr_code_icon/1484103054333d7373e76bfd44727869d37ec96f89ab608d8d388-6896a8696b8038f4fc8989ab005e4fccc3b90047.jpg', null, 'prod_icon/148410305433338a0ac47ec4701b26d58656b8ddd5ee49d497b1b-1f50826eb97557267e9bf48728c9874810833481.jpg', '', '8', '4,5,9', 'images/148420907169581.jpg,images/148420907169582.jpg,images/148420907169583.jpg,images/148420907169584.jpg', '0', '2017-01-11', 'wolfme', '19', '0', '0', '0'), ('142', '91影像助手', '「91影像助手」是一款医学影像查询工具，搭建了一个医学影像信息数据库，用户可以通过点击分类菜单栏、输入关键词搜索查询医学影像的相关内容。「91影像助手」隶属于杭州至临医疗科技有限公司（以下简称”至临医疗科技”），主要为医生群体提供系统化、便捷化的医学影像信息查询服务。 医生在工作和学习中遇到需要查询资料的情况时，可以通过检索「91影像助手」来获取相关信息。', 'qr_code_icon/148410324932381ed888b16923274c8fa4920e0399072920e3007-fdf0a38da91bfadfa13254b1dfb759f33dcae878.jpg', null, 'prod_icon/148410324932398540da547124a9d685ac13cf03b2e7e95ae48c9-97dd1abb96b2e967fe1c632e2f314bb8a74ed871.jpg', '', '8', '3,4,6,10,13', 'images/148420918366885.png,images/148420918368386.jpg,images/148420918368387.jpg,images/148420918368388.jpg', '0', '2017-01-11', 'susan', '19', '0', '0', '2'), ('143', '小小包麻麻好物', '300万父母关注！正确辅食添加，幼儿疾病护理，母婴用品评测，0-4岁前沿育儿知识全在这里！', 'qr_code_icon/148410346973513a39cf51b5e939f2bf3b0ba8803a8d71ad69ccb-e203473ee16b37bdac47a1f2640ad313e27ebe0d.jpg', null, 'prod_icon/14841034697350ebf1924bf201f9af2eacc32cdf2ad567cd49610-42573d7391a7bc9dcdef39375562aa088c386c85.jpg', '', '8', '4,5,9,12,18', 'images/148420933579991.png,images/148420933579992.png,images/148420933579993.png', '0', '2017-01-11', 'dada', '19', '0', '0', '1'), ('144', '爱弹唱', '吉他谱子 尤克里里谱子 吉他谱 尤克里里谱 吉他教学 尤克里里教学', 'qr_code_icon/148410369855322.jpg', null, 'prod_icon/148410369855321.jpg', '', '8', '4,6,9,18', 'images/148420941614595.jpg,images/148420941614596.jpg,images/148420941614597.jpg', '0', '2017-01-11', '爱弹唱', '19', '0', '0', '1'), ('145', '世界大学排行榜', '世界大学排行榜收录了USNews，QS，泰晤士，上海交大等多个机构各类型各年份数百个排行榜。为学生留学申请选校提供参考。', 'qr_code_icon/1484103898792f210108f965a8d7eb1ccacf640a6e42240c06d85-099d4fcd39fcd260815935b19dce85998448649c.jpg', null, 'prod_icon/14841038987927a2049d5895f905561c159cd24007345f8a0cd17-9d7847bb10528374a56eb710234177a32be68bea.jpg', '', '8', '4,5,6', 'images/148420953336911.png,images/148420953336912.png,images/148420953336913.png,images/148420953338414.png', '0', '2017-01-11', 'Zinch', '19', '0', '0', '0'), ('147', '分答快问', '“分答快问”是聚集了付费语音问答平台「分答」上的优质答主。当你遇到各领域的任何问题，都可以在短时间内得到专业化语音解答。', 'qr_code_icon/148410427455232.png', null, 'prod_icon/148410427455231.png', '', '8', '4,5,6,9,18', 'images/148420961021515.png,images/148420961021516.png,images/148420961021517.png', '0', '2017-01-11', '分答', '19', '0', '0', '1'), ('148', '化妆品点评', '你的美妆消费指南—美妆界的大众点评，中国COSME！消费者真实口碑，杜绝水军！买前查口碑，拔草不后悔！', 'qr_code_icon/148410452904312.jpg', null, 'prod_icon/148410452904311.jpg', '', '8', '4,6,9,12', 'images/148420968174921.png,images/148420968174922.png,images/148420968174923.png,images/148420968174924.png', '0', '2017-01-11', '美妆心得', '19', '0', '0', '0'), ('149', '蝌蚪课+', '蝌蚪课——您手机上的免费音乐课!', 'qr_code_icon/148410464454622.jpg', null, 'prod_icon/148410464454621.jpg', '', '8', '4', 'images/148420979653526.jpg,images/148420979655127.jpg,images/148420979655128.jpg', '0', '2017-01-11', '蝌蚪课', '19', '0', '0', '1'), ('151', '多伦多生活黄页', '加拿大多伦多生活必备利器，分类信息涵盖生活方方方面，装修、通渠、接送、家教、法律、报税、保险、汽车、交友、婚恋、家政、签证、机票、外汇、旅游、中医、牙医、生意服务，等等，无所不有。还有多伦多常用电话查询、天气预报，让你加国无忧。', 'qr_code_icon/148410518601312.jpg', null, 'prod_icon/148410518601311.jpg', '', '7', '2,4,6,9,11', 'images/148421076507231.jpg,images/148421076508832.jpg,images/148421076508833.jpg,images/148421076508834.jpg', '0', '2017-01-11', '加国无忧', '19', '0', '0', '2'), ('152', '留学公寓助手', '留学公寓助手，是由番茄留学公寓平台开发，免费为中国留学生提供学校及校外的学生公寓预订服务的小程序。', 'qr_code_icon/148410536340822.png', null, 'prod_icon/148410536340821.png', '', '8', '4,9', 'images/148410536340823.png,images/148410536340824.png,images/148410536340825.png', '0', '2017-01-11', 'SHU', '19', '0', '0', '0'), ('153', '小蚁AI艺术', '小蚁AI技术，深度学习画风，一键将照片变身艺术品', 'qr_code_icon/148410552377232.png', null, 'prod_icon/148410552377231.png', '', '8', '4,5,6,10,18', 'images/148420814647111.jpg', '0', '2017-01-11', '小蚁科技', '19', '0', '0', '0'), ('154', '钢琴优课', '您手机上优选的免费钢琴课。', 'qr_code_icon/148410566182212.jpg', null, 'prod_icon/148410566182211.jpg', '', '8', '4', 'images/148421086748336.jpg,images/148421086748337.jpg,images/148421086748338.jpg', '0', '2017-01-11', '蝌蚪课', '19', '0', '0', '0'), ('155', '翻译e', '多国语言在线翻译，中英、中日、中俄、中法快速翻译，专业翻译', 'qr_code_icon/148410571507322.jpg', null, 'prod_icon/148410571507321.jpg', '', '8', '4,6,9,11', 'images/148410571507323.png,images/148410571508924.png', '0', '2017-01-11', '邓仔', '19', '0', '0', '0'), ('156', '呤呤英语机器人', '机器人帮孩子学英语？是的！呤呤英语机器人，和小朋友玩单词游戏、练习简单对话，还可以帮小朋友纠正发音哦！足不出户，找到随时和小朋友学英语的好伙伴，快来试试吧！', 'qr_code_icon/148410586882732.jpg', null, 'prod_icon/148410586882731.jpg', '', '8', '4,6', 'images/148421097458041.jpg,images/148421097458042.jpg,images/148421097458043.jpg', '0', '2017-01-11', 'snaplingo', '19', '0', '0', '0'), ('157', '妈妈网孕育', '妈妈的世界，只有妈妈懂！ 妈妈网孕育，最懂妈妈的小程序！ 精准的孕育知识经验搜索，定制化的孕期育儿每日知识，丰富好用的孕期育儿工具，帮你做更好的妈妈！', 'qr_code_icon/148410604434812.jpg', null, 'prod_icon/148410604434811.jpg', '', '8', '4,6,9,13', 'images/148421109463246.png,images/148421109463247.png,images/148421109463248.png', '0', '2017-01-11', '妈妈网', '19', '0', '0', '0'), ('158', '小D词典', '沪江小D词典是沪江推出的国内领先的多语种在线词典。界面清爽简洁，内容专业权威以及功能实用，让它成为千万用户的查词首选。', 'qr_code_icon/148410618500722.jpg', null, 'prod_icon/148410618500721.png', '', '8', '4,6,9,10', 'images/148421126820146.jpg,images/148421126820147.jpg,images/148421126820148.jpg,images/148421126820149.jpg', '0', '2017-01-11', '徐勇', '19', '0', '0', '0'), ('159', '换阅空间', '分享好书，换享阅读', 'qr_code_icon/148410632672852.jpg', null, 'prod_icon/148410632672851.jpg', '', '8', '4,6,18', 'images/148421156561951.png,images/148421156563452.png,images/148421156563453.png,images/148421156563454.png', '0', '2017-01-11', '余波', '19', '0', '0', '0'), ('160', 'We重邮', '校园微移动门户，为全校师生提供便捷服务。', 'qr_code_icon/148410659360812.jpg', null, 'prod_icon/148410659360811.png', '', '8', '4,6', 'images/148410659360813.png,images/148410659362414.png,images/148410659362415.png,images/148410659362416.png', '0', '2017-01-11', '这是昵称', '19', '0', '0', '0'), ('161', '感恩笔记本', '感恩笔记本-用感恩的心看世界，记录生命给予的每一份美好礼物，拯救不开心。 美国脱口秀女王 Oprah 坚持写感恩笔记 已有十年，她鼓励所有人用感恩的心看世界， 记录生命给予的每一份美好礼物， 拯救不开心。', 'qr_code_icon/148410671251742.jpg', null, 'prod_icon/148410671251741.jpg', '', '8', '4,6,9', 'images/148421182242361.png,images/148421182242362.png,images/148421182242363.png', '0', '2017-01-11', 'Zeo', '19', '0', '0', '0'), ('162', '扇贝小字典', '一个简洁的英文词典', 'qr_code_icon/148410844826912.jpg', null, 'prod_icon/148410844826911.png', '', '8', '4,6,9,10', 'images/148421191344166.png,images/148421191344168.png,images/148421191344169.png', '0', '2017-01-11', '赵余', '19', '0', '0', '0'), ('163', '天天练口语', '天天练口语，提供轻量级、多样化的口语练习服务，趣味与实用结合的口语学习模式，让口语练习不再枯燥！', 'qr_code_icon/148410854592712.jpg', null, 'prod_icon/148410854592711.png', '', '8', '4,5,6,10', 'images/148410854592713.jpg,images/148410854592714.jpg', '0', '2017-01-11', '沪江', '19', '0', '0', '0'), ('165', '荔枝FM播客', '荔枝FM，人人都是播客，最具原创活力的播客平台。通过荔枝FM小程序，可随时随地收听声音电台直播。', 'qr_code_icon/148410869711824.jpg', null, 'prod_icon/148410869711821.png', '', '8', '4,5,6,11', 'images/148421239785671.png,images/148421239785672.png', '0', '2017-01-11', 'lizhiapp', '19', '0', '0', '0'), ('167', '小密圈', '小密圈是创作者连接铁杆粉丝，做出高品质社群，实现知识变现的工具。 凯文·凯利提出过「一千位铁杆粉丝」的观点：任何从事创作或艺术的人，例如艺术家、音乐家、摄影师、工匠、演员、动画师、设计师、作家等，只要能获得一千位铁杆粉丝，就足够生计无忧，自由创作。 到小密圈建一个圈子，按年收费，为自己的热爱写作，为自己的朋友写作。第二年，大多数用户还会在，一次销售，提供好的内容，粉丝会和你连接得越来越牢固。你的压力可能不会减少，你的快乐和满足感一定会增加。', 'qr_code_icon/148410879082332.jpg', null, 'prod_icon/148410879082331.png', '', '8', '4,6,10,18', 'images/148410879082333.png,images/148410879082334.png,images/148410879082335.png', '0', '2017-01-11', 'wulujia', '19', '0', '0', '0'), ('168', '人人词典', '人人影视字幕组官方旗下产品,基于字幕组十年来积累的美剧日剧双语字幕大数据打造的的词典应用。开创性的采用声像并茂的双语字幕作为例句来诠释单词。', 'qr_code_icon/148411519765442.jpg', null, 'prod_icon/148411519765441.png', '', '8', '4,6', 'images/148421267128476.png,images/148421267128477.png,images/148421267128478.png,images/148421267128479.png', '0', '2017-01-11', '铜矿', '19', '0', '0', '3'), ('169', '西窗诗词', '品味唐诗宋词之美。 * 简约排版，干净优雅 * 50万首海量诗词歌赋 * 喜欢的诗，收藏一下 * 来听大家念诗！', 'qr_code_icon/1484120029067e6557981ab48f0c80b7162c91ac178603a9b1471-612d295e29de2c4442f411d318cfc03669bde1f9.jpg', null, 'prod_icon/1484120029099015013bde9fb4bdba27a04f3704fd714808999fd-d92a995d4ecca5221b9b20df9890e0151076eea2.png', '', '8', '4,5,6', 'images/148421275622381.png,images/148421275622382.png,images/148421275622383.png,images/148421275622384.png', '0', '2017-01-11', '刘志鹏', '19', '0', '0', '0'), ('170', '懒虫背单词', '专业的英语学习软件.词汇涵盖:高中,四六级,考研,托福,雅思,托业,SAT,GRE,GMAT,行业英语.科学方法:智能推送每日任务,高效记忆。', 'qr_code_icon/148412255169312.jpg', null, 'prod_icon/148412255169311.png', '', '8', '4', 'images/148421282530286.jpg,images/148421282530287.jpg,images/148421282530288.jpg,images/148421282531889.jpg', '0', '2017-01-11', 'iless', '19', '0', '0', '0'), ('172', '趣住啊民宿', '趣住啊－一个有趣的海外民宿预定及社交平台 趣住啊，由具有互联网背景的自由行玩家踏遍全球美景后，热血而造 趣住啊，不断丰富平台上的全球民宿，最自由的出行方式 搭建您与民宿主人最直接的沟通桥梁，感受世间的风土人情，让旅行更有深度 趣住啊特色功能 －为您精选海外民宿，体验最当地的人情之旅 －直接联系房东，沟通无障碍 －当地人合作管理模式，保证民宿品质，让您安心入住 －支持支付宝和微信支付，人民币结算，预订快捷方便 趣住啊，趣住进世界。 请关注我们 官方网站：www.bnbtrip.com 新浪微博：趣住啊 微信公众号：趣住啊', 'qr_code_icon/148412388520122.jpg', null, 'prod_icon/1484207911921287e376dbabb859efd8dad539e3021d5402bf9cb-a0dcd7fbbcba9dad42759929b02fdbd52bd03aeb.png', '', '3', '2,6,8,9,11', 'images/148420791193741.png,images/148420791193742.png,images/148420791193743.png,images/148420791193744.jpg', '0', '2017-01-11', '趣住啊', '19', '0', '0', '3'), ('173', '种子时间', '「种子时间」- 放下手机，享受生活 我们希望帮助用户能够更加专注的去做一件事，而不被玩手机等不必要的因素干扰或打断。', 'qr_code_icon/148421527944342.jpg', null, 'prod_icon/148421527944341.jpg', '', '24', '4,6', 'images/148421527945943.png,images/148421527945944.png,images/148421527945945.png', '0', '2017-01-11', 'miniapp.com', '19', '0', '0', '11'), ('175', '星际社区', '星际社区是星际联盟的下属app，在这里，我们为你提供最新的，最时尚的装X科技，以及你需要的生活便利，我们期待您的加入！', 'qr_code_icon/14841250525371.png', null, 'prod_icon/14841250525372.png', '', '23', null, 'images/14841250525373.png,images/14841250525374.png,images/14841250525375.png,images/14841250525376.png', '0', '2017-01-11', '宝宝233', '16', '0', '0', '2'), ('176', '果粉必备乐乐达', '乐乐达是苹果官方授权的O2O经销商，业务范围覆盖手机维修、新机销售、以旧换新，二手回收等', 'qr_code_icon/14841251541781.jpg', null, 'prod_icon/14841251541782.png', '', '3', null, 'images/14841251541783.jpg,images/14841251541784.jpg,images/14841251541785.jpg', '0', '2017-01-11', 'GINGER', '16', '0', '0', '0'), ('177', '飞机票查询预订', '艺龙旅行网为消费者提供全球200多个国家75万家酒店住宿及飞机票、火车票等预定服务；是中国在线和移动住宿服务提供商,致力于打造专注专业、物超所值、智能便捷的住宿预订平台,通过艺龙客户端、PC网站、24小时预订热线（4009-333-333）,更多详情请登录艺龙官网www.elong.com!', 'qr_code_icon/14841252483821.jpg', null, 'prod_icon/14841252483822.jpg', '', '4', null, 'images/14841252483823.jpg,images/14841252483824.jpg,images/14841252483825.jpg,images/14841252483826.jpg', '0', '2017-01-11', '艺龙网信息技术（北京）有限公司', '16', '0', '0', '0'), ('178', '火车票预订查询', '艺龙旅行网为消费者提供全球200多个国家75万家酒店住宿及机票、火车票等预定服务；是中国在线和移动住宿服务提供商,致力于打造专注专业、物超所值、智能便捷的住宿预订平台,通过艺龙客户端、PC网站、24小时预订热线（4009-333-333）,更多详情请登录艺龙官网www.elong.com!', 'qr_code_icon/14841253183361.jpg', null, 'prod_icon/14841253183362.jpg', '', '4', null, 'images/14841253183363.jpg,images/14841253183364.jpg,images/14841253183365.jpg,images/14841253183366.jpg', '0', '2017-01-11', '艺龙网信息技术（北京）有限公司', '16', '0', '0', '0'), ('179', '华东师范大学校园服务', '华东师范大学校园服务平台。提供成绩查询、课表查询、考试信息查询、校园卡查询、工资酬金查询、宿舍电量查询、图书借阅查询、讲座查询、通知公告查询等功能。', 'qr_code_icon/14841253909921.jpg', null, 'prod_icon/14841253909922.png', '', '8', null, 'images/14841253909923.png,images/14841253909924.png,images/14841253909925.png,images/14841253909926.png', '0', '2017-01-11', '刘欢', '16', '0', '0', '0'), ('180', '车300评估', '车300，国内领先的独立第三方二手车评估平台。车300提供二手车精准定价，降低二手车交易风险，致力促成行情透明化。', 'qr_code_icon/14841254485401.jpg', null, 'prod_icon/14841254485402.jpg', '', '3', null, 'images/14841254485403.jpg,images/14841254485404.jpg', '0', '2017-01-11', '镜子狼', '16', '0', '0', '1'), ('181', '艺龙酒店预订', '艺龙旅行网为消费者提供全球200多个国家75万家酒店住宿及机票、火车票等预定服务；是中国在线和移动住宿服务提供商,致力于打造专注专业、物超所值、智能便捷的住宿预订平台,通过艺龙客户端、PC网站、24小时预订热线（4009-333-333）,更多详情请登录艺龙官网www.elong.com!', 'qr_code_icon/14841255422901.png', null, 'prod_icon/14841255422902.png', '', '2', null, 'images/14841255422903.jpg,images/14841255422904.jpg,images/14841255422905.jpg,images/14841255422906.jpg', '0', '2017-01-11', '艺龙网信息技术（北京）有限公司', '16', '4', '4', '6'), ('182', '有书想读', '选择一本书，告诉有书。有书帮你拆解、完成阅读心愿。', 'qr_code_icon/14841256173531.png', null, 'prod_icon/14841256173532.jpg', '', '13', null, 'images/14841256173533.png,images/14841256173534.png,images/14841256173535.png', '0', '2017-01-11', 'Bob', '16', '0', '0', '7'), ('183', '车车汽配云', '国内最全面的车型与配件对应关系查询，配件价格查询，养车必备!!', 'qr_code_icon/14841256927131.png', null, 'prod_icon/14841256927292.png', '', '9', null, 'images/14841256927293.png,images/14841256927294.png,images/14841256927295.png,images/14841256927296.png', '0', '2017-01-11', 'Oser', '16', '0', '0', '0'), ('184', '美团外卖+', '美团外卖，目前国内最大的外卖网上订餐平台。美团外卖提供北京，上海，杭州，广州，天津等全国300城市网上订餐，附近的外卖送餐，药品，网上超市百货，水果外卖，上美团外卖官网。', 'qr_code_icon/14841257562131.jpg', 'mp_code_icon/1484997855747t018987766d604346ad.jpg', 'prod_icon/14841257562132.png', '', '15', '6,9', 'images/14841257562133.jpg,images/14841257562134.jpg', '0', '2017-01-11', 'OpenGG', '16', '5', '6', '15'), ('185', '58同城', '58同城为你提供本地生活服务信息，找工作，找房子，找车、买二手买宠物，随时查看即时沟通，都在58同城小程序版。', 'qr_code_icon/14841258457761.png', null, 'prod_icon/14841258457762.jpg', '', '20', null, 'images/14841258457763.jpg,images/14841258457764.jpg,images/14841258457765.jpg', '0', '2017-01-11', 'inpeking', '16', '5', '2', '6'), ('186', '领航员投资挑战赛', '领航员投资挑战赛是上海求真创业投资有限公司推出的一款虚拟投资平台，致力于培养高校专业投资者和理性投资者，树立正确投资观念。', 'qr_code_icon/14841259329331.jpg', null, 'prod_icon/14841259329332.png', '', '11', null, 'images/14841259329333.jpg,images/14841259329334.jpg,images/14841259329335.jpg,images/14841259329336.jpg', '0', '2017-01-11', '领航员app', '16', '0', '0', '1'), ('187', '微快递', '微快递+是为用户提供快递综合解决方案，提供最全查快递、寄快递，提升客户的快递使用体验和满足个性化服务需求。', 'qr_code_icon/14841260106211.jpg', null, 'prod_icon/14841260106372.png', '', '3', null, 'images/14841260106373.png,images/14841260106374.png,images/14841260106375.png', '0', '2017-01-11', '快递助手', '16', '0', '0', '4'), ('189', '买房利器', '为购房者提供找房、搜房服务。', 'qr_code_icon/148412674654822.jpg', null, 'prod_icon/148412674654821.jpg', '', '24', '8,9', 'images/14842129375541111.png', '0', '2017-01-11', '乐居控股', '19', '5', '2', '13'), ('191', '楼市报导', '丰富、及时、深度，你想看的楼市新闻都在这里。', 'qr_code_icon/148412693389332.jpg', null, 'prod_icon/148412693389331.jpg', '', '24', '8', 'images/148412693389333.png,images/148412693389334.png,images/148412693389335.png', '0', '2017-01-11', '乐居控股', '19', '0', '0', '2'), ('192', '新安买房', '“新安买房”小程序是专门为买房者提供更加便捷的找房服务，更新更全的楼盘信息、全面直观的房源详情，多种维度的条件筛选，还有电话咨询、预约看房……找你所想，便捷准确，一键触达，让你买房更简单。', 'qr_code_icon/148412711367742.jpg', null, 'prod_icon/148412711367741.png', '', '24', '6,8', 'images/148421303750991.png,images/148421303750992.png,images/148421303750993.png,images/148421303750994.png', '0', '2017-01-11', '新安买房', '19', '0', '0', '0'), ('193', '算车价', '2017年最新的购车计算器,方便购车者计算购车时所产生的各种税费(购置税、上牌费用、车船使用税等)以及商业保险。', 'qr_code_icon/14841271526011.jpg', null, 'prod_icon/14841271526012.jpg', '', '3', null, 'images/14841271526013.jpg', '0', '2017-01-11', '玩车教授', '16', '0', '0', '0'), ('194', '汽车报价库', '汽车报价库囊括9000多款车型，全国20000多家合作经销商，为您提供最专业贴心的汽车查询服务。', 'qr_code_icon/14841272242291.png', null, 'prod_icon/14841272242292.png', '', '9', null, 'images/1484127224229d2a519315dbe947add77f38a55029a123f9f8d0a-ce93202a26da3557c6f45b4a9d64336ceee5e353.jpg', '0', '2017-01-11', '玩车教授', '16', '0', '0', '1'), ('195', '饿了么外卖服务', '饿了就用饿了么！小程序版，更方便，微信也能点外卖。', 'qr_code_icon/14841272899661.png', null, 'prod_icon/14841272899662.png', '', '15', null, 'images/14841272899663.png,images/14841272899664.png', '0', '2017-01-11', 'Joe_志文', '16', '4', '4', '9'), ('196', '房贷计算器免费版', '免费房贷工具，2017买房卖房必备。全面覆盖公积金贷款、商业贷款、组合贷款，利率实时调整，买房卖房专业房贷计算好帮手！', 'qr_code_icon/148412731682712.jpg', null, 'prod_icon/148412731682711.jpg', '', '7', '1,6,8,9,14', 'images/148421313546496.png,images/148421313548097.png,images/148421313548098.png,images/148421313548099.png', '0', '2017-01-11', '金雨', '19', '0', '0', '14'), ('197', '极简汇率', '从自身多年的出境经验出发，设计出快而准的银联汇率换算工具，是你出境游/境外购物等进行汇率换算的贴心助手。 小贴士： 1.点击国旗可切换货币 2.小程序汇率源为银联卡境外刷卡汇率——「银联汇率」', 'qr_code_icon/14841273530941.jpg', null, 'prod_icon/14841273530942.jpg', '', '7', null, 'images/14841273530943.png,images/14841273530944.png', '0', '2017-01-11', 'traveltao', '16', '0', '0', '0'), ('198', '滴滴出行DIDI', '滴滴一下，随叫随到。滴滴出行小程序版，迅速，快捷。', 'qr_code_icon/14841274445831.png', 'mp_code_icon/1484998687795t011455568fe5c0807a.jpg', 'prod_icon/14841274445832.png', '', '4', '6,7', 'images/14841274445833.jpg,images/14841274445834.jpg', '0', '2017-01-11', 'Joe_志文', '16', '3', '5', '15'), ('199', '土巴兔装修效果图', '土巴兔家居装修是新房,二手房,工装等各类房屋室内设计,装潢装饰效果图,半包全包家庭家居装修首选一站式服务平台,包含装修公司、装修工人的家装平台。 土巴兔成立于2008年，是面向用户的一站式家装服务平台，目前已开通250个城市分站，累计服务1400万中国家庭。在土巴兔，用户可获得免费验房、免费设计与报价、免费监理、家居电商、品质施工、装修贷款等服务，一站式享受品质家装，让您省钱、省心、省时间。 打开微信，搜索\"土巴兔\"即可访问。 咨询热线：4006-900-288 网址：www.to8to.com', 'qr_code_icon/148412752866532.jpg', null, 'prod_icon/148412752868031.jpg', '', '24', '2,6,8,9,15', 'images/148421325974811.jpg,images/148421325974812.jpg,images/148421325974813.jpg,images/148421325974814.jpg', '0', '2017-01-11', '土巴兔', '19', '0', '0', '4'), ('201', '上海房产税计算器', '房产税计算器根据上海地税局的计算方法，各家庭都可根据自身住房情况进行计算，具体结果以地税局为准或至付费通平台进行查询。', 'qr_code_icon/148412783488152.jpg', null, 'prod_icon/148412783488151.png', '', '7', '6,8,14', 'images/148421350301821.png,images/148421350301822.png,images/148421350301823.png', '0', '2017-01-11', '付费通', '19', '0', '0', '0'), ('202', '嗨住租房', '嗨住，一个专业的租房平台，为您提供更真实更便捷的创新一站式租房服务。让租房世界从此变得简单而温暖。在我们不断的改进和优化中，力求让更多的用户获得前所未有的体验。 — 智能+人工，双重筛选，保证所有房源真实有效，让找房不再海量筛选； — 0元中介费，让“不收中介费”的找房神话不再是传说； — 第三方监管，房租押金有担保，先行赔付； — 白条付租、信用卡付租、室友征选、搬家、维修更多服务，请移步任意手机应用市场下载“嗨住”。 【联系方式】 1、微信公众号：嗨住hizhu 2、微博账号：嗨住hizhu 3、服务热线：400-8786-999', 'qr_code_icon/148412811361362.jpg', null, 'prod_icon/148412811361361.png', '', '24', '2,6,8,9,15', 'images/148421358431726.jpg,images/148421358431727.jpg,images/148421358431728.jpg,images/148421358431729.jpg', '0', '2017-01-11', '钱赵力@hizhu.com', '19', '3', '3', '7'), ('203', '加油卡充值', '由《一号养车》提供汽车加油卡快速充值服务，最快0.5小时内到账，支持全国各地的中国石油加油卡和中国石化加油卡的充值服务。', 'qr_code_icon/14841283390291.jpg', null, 'prod_icon/14841283390292.jpg', '', '4', null, 'images/14841283390293.jpg,images/14841283390294.jpg,images/14841283390295.jpg', '0', '2017-01-11', '等线牵的风筝', '16', '0', '0', '0'), ('204', '闪电刷新用户版', '闪电刷新，专业墙面刷新专家。极致保护，无须动手，施工满意后再付款。手机免费预约，一键焕新家。', 'qr_code_icon/148412835570212.jpg', null, 'prod_icon/148412835570211.png', '', '24', '2,8,9,15', 'images/148421365197431.jpg,images/148421365197432.jpg,images/148421365197433.jpg,images/148421365197434.jpg', '0', '2017-01-11', '闪电刷新', '19', '0', '0', '0'), ('205', '猫眼电影', '一如既往为大家提供电影购票福利', 'qr_code_icon/14841284034691.png', null, 'prod_icon/14841284034692.png', '', '12', null, 'images/14841284034693.png,images/14841284034694.png', '0', '2017-01-11', 'Joe_志文', '16', '0', '0', '1'), ('207', '赢了网法律服务', '资深律师和专家通过文字或电话解答法律问题，提供行动建议。业务覆盖各类民事纠纷和刑事案件。相关法律服务由赢了网独家提供。', 'qr_code_icon/14841285254591.jpg', null, 'prod_icon/14841285254592.jpg', '', '7', null, 'images/14841285254593.jpg,images/14841285254594.jpg,images/14841285254595.jpg,images/14841285254596.jpg', '0', '2017-01-11', '赢了网', '16', '0', '0', '0'), ('208', '指尖快递pro', '指尖快递是一款快递服务应用，为您提供上百家国内外快递查询、在线寄件的服务。查、收快递 , 实时跟踪物流，快递跃然指尖！', 'qr_code_icon/14841286060101.jpg', null, 'prod_icon/14841286060252.png', '', '9', null, 'images/14841286060253.jpg,images/14841286060254.png,images/14841286060255.png,images/14841286060256.png', '0', '2017-01-11', '王慧永', '16', '0', '0', '2'), ('210', '每日优鲜', '全球精选生鲜，2小时速达！新鲜果蔬、海鲜肉禽、酒水饮品、进口零食、营养牛奶，我们采取全程冷链+严格品控，只为您新鲜到家！', 'qr_code_icon/14841287108111.jpg', null, 'prod_icon/14841287108112.png', '', '15', null, 'images/14841287108113.png,images/14841287108114.png,images/14841287108115.jpg', '0', '2017-01-11', 'nie~', '16', '5', '1', '3'), ('211', '情侣相册', '和恋人共同管理你们的照片和视频。两人共用的私密空间，照片视频轻松上传云端存储。', 'qr_code_icon/14841288004091.jpg', null, 'prod_icon/14841288004092.png', '', '23', null, 'images/14841288004093.png,images/14841288004094.png,images/14841288004095.png', '0', '2017-01-11', '恋爱记', '16', '0', '0', '0'), ('212', '房美汇海外房产', '房美汇海外房产平台是最值得信赖的海外购房平台，为华人提供及时、完善、海量的海外房产信息', 'qr_code_icon/148413072027562.jpg', null, 'prod_icon/148413072027561.jpg', '', '24', '8', 'images/148421372067936.jpg,images/148421372067937.jpg,images/148421372067938.jpg,images/148421372067939.jpg', '0', '2017-01-11', '房美汇', '19', '0', '0', '0'), ('213', '家装精品案例', '家装精品案例，每套案例从客厅、餐厅、厨房、书房、卧室等空间出发，贯通其设计及搭配妙法，展现一个完整地设计灵感。', 'qr_code_icon/148413100990642.jpg', null, 'prod_icon/148413100990641.png', '', '24', '2,6,8,9', 'images/148421383790041.jpg,images/148421383791542.png,images/148421383791543.jpg,images/148421383791544.jpg', '0', '2017-01-11', '家装精品案例', '19', '0', '0', '2'), ('217', '听闻FM电台', '随时随地用语音来感受新闻热点的软件，奇闻、体育、娱乐、财经、科技、真人录制每日在线更新。', 'qr_code_icon/148413178060812.jpg', null, 'prod_icon/148413178060811.jpg', '', '21', '2,4,5,6,10', 'images/148421393705846.png,images/148421393705847.png,images/148421393705848.png', '0', '2017-01-11', '听闻', '19', '0', '0', '0'), ('218', '发声吧TV', '发声吧TV,让一切有趣的人和事发声', 'qr_code_icon/148413210813022.jpg', null, 'prod_icon/148413210813021.jpg', '', '8', '3,4,18', 'images/148421471958921.png,images/148421471958922.png,images/148421471958923.png,images/148421471958924.png', '0', '2017-01-11', '发声吧TV', '19', '0', '0', '2'), ('219', '怒马课堂', '怒马是虎嗅推出的知识分享平台，面向所有互联网人，发布经验分享和知识学习的课程，内容涉及产品、运营、技术、创业和其他有趣的杂学。', 'qr_code_icon/148413226882142.jpg', null, 'prod_icon/148413226882141.jpg', '', '8', '4,10', 'images/148421465374416.png,images/148421465374417.png,images/148421465374418.png', '0', '2017-01-11', 'kong', '19', '0', '0', '0'), ('221', '食物派Lite', '查询食物营养信息，热量（卡路里）、碳水化合物、脂肪、蛋白质。减肥健身饮食必备。', 'qr_code_icon/148418942336812.jpg', null, 'prod_icon/148418942336811.jpg', '', '15', '6,9', 'images/148421434517576.png,images/148421434517577.png,images/148421434517578.png,images/148421434517579.png', '0', '2017-01-12', 'itisalex', '19', '0', '0', '14'), ('223', '美食天下', '海量菜谱与美食社区，教你一步一步做美食', 'qr_code_icon/148418972846722.jpg', 'mp_code_icon/1484998759718t0133c3b4eb0e07f6bc.jpg', 'prod_icon/148418972846721.png', '', '15', '9', 'images/148421446249082.png,images/148421446249083.png,images/148421446249084.png,images/148421448941281.png', '0', '2017-01-12', '美食天下', '19', '0', '0', '27'), ('224', '汕头生活+', '「汕头生活+」是第一款服务于区域自媒体的小程序，在这里你可以了解第一手的汕头新鲜事，浏览纯正的潮语搞笑视频，与潮人圈子的你我他激萌互动！ 「汕头生活+」依靠于区域自媒体小程序平台 -- 海螺云（hailuoyun.cn）。海螺云致力于帮助公众号主以零技术的投入切入到小程序中，丰富小程序的生态，微信:dawnsail。', 'qr_code_icon/148418986800112.png', null, 'prod_icon/148418986800111.png', '', '15', '5,9', 'images/148421459950811.png,images/148421459952412.png,images/148421459952413.png', '0', '2017-01-12', '红雨点苍苔', '19', '5', '2', '4'), ('225', '豆果美食菜谱精选厨房必备', '最 In 的美食推荐、最贴心的时令食材、最多样的菜谱方案，随时随地 hold 住你的胃，变革你的厨房体验。豆果美食，开启美味生活。', 'qr_code_icon/148418997470622.jpg', null, 'prod_icon/148418997470621.png', '', '15', '9,18', 'images/148421477601126.jpg,images/148421477601127.jpg,images/148421477601128.jpg', '0', '2017-01-12', '豆果美食', '19', '5', '2', '3'), ('226', '探城美食APP', '探城是专注于发现与分享的精品美食社区，一款吃货必备的优质美食探店神器，每日精选探文推荐同城美味好餐厅，已开通全国11个热门城市。', 'qr_code_icon/148419049223232.jpg', null, 'prod_icon/148419049223231.png', '', '15', '9,11', 'images/148421485038831.png,images/148421485038832.png,images/148421485038833.png,images/148421485038834.png', '0', '2017-01-12', '香灰', '19', '5', '2', '3'), ('227', '订蛋糕', '大牌蛋糕在线预订，最快3小时送达，更有限时抢购优惠多多。 合作商家包括：黑天鹅、21cake、元祖、味多美等等上百商家。', 'qr_code_icon/148419063642242.jpg', null, 'prod_icon/148419063642241.png', '', '15', '2,9,12', 'images/14842148906541111111.jpg', '0', '2017-01-12', '生日管家', '19', '0', '0', '0'), ('228', '鬼畜表情包', '鬼畜表情——有趣的微信聊天斗图表情分享工具。', 'qr_code_icon/148419088581652.jpg', null, 'prod_icon/148419088581651.jpg', '', '18', '5,6,18', 'images/148421408629551.png,images/148421408629552.png', '0', '2017-01-12', '二三三数字科技', '19', '0', '0', '10'), ('229', '动动文字', '非常傻瓜好玩的一款小程序，能将任意文字变成动态图片。有多种特效可以选择，你只需要选好特效，然后输入文字，就可以一键生成动态文字。可以用于表情包、群聊斗图、文章配图等。简直是聊天、耍酷、卖萌、祝福必备的终极神器！用一用，保准让你的朋友惊讶不已~！对了，评论里有个别用户反馈的乱码问题，已经解决。谢谢你们！（上面的截屏是静态图，实际动态效果超级棒的哦~） 。', 'qr_code_icon/148419101233262.jpg', null, 'prod_icon/148419101233261.jpg', '', '18', '5,6,10,18', 'images/148421414610966.jpg,images/148421414610967.png,images/148421414610968.png', '0', '2017-01-12', '动动文字', '19', '0', '0', '3'), ('230', '表情家园', '上传图片制作自己的表情图片，所有表情图片都可以改字。最全的表情包图片，有搞笑表情包，暴走表情包， 黄子韬表情包， 尔康表情包， 金馆长表情包， 斗图表情包， 带字表情包， 动态表情包。', 'qr_code_icon/148419116533312.jpg', null, 'prod_icon/148419116533311.png', '', '18', '5,6,9,18', 'images/148421422687671.jpg,images/148421422689272.jpg,images/148421422689273.jpg,images/148421422689274.jpg', '0', '2017-01-12', 'Longxi', '19', '5', '1', '9'), ('231', '量子足球', '量子足球是一家专注于足球比赛大数据的公司，依靠公司独创的数据模型，对足球比赛数据进行实时分析，并通过多种展现方式，将比赛的进程展示给用户。 目前量子足球拥有独家的量子进球指数、球员评分体系等数据模型，并且成为中国首家发布期望进球(Expected Goals)的足球大数据公司。现已经与中超、英超和西甲等多家顶级联赛俱乐部以及媒体机构成为合作伙伴。', 'qr_code_icon/148420150716512.png', null, 'prod_icon/148420150716511.png', '', '17', '5,6,17', 'images/148420150716513.jpg,images/148420150718014.jpg,images/148420150718015.jpg,images/148420150718016.jpg', '0', '2017-01-12', '阿布', '19', '0', '0', '0'), ('236', '酷竞', 'NBA 数据一网打尽，快速全面查看赛程，球员伤停。', 'qr_code_icon/148426957459212.jpg', null, 'prod_icon/148426957460811.jpg', '', '17', '17', 'images/148426957460813.png,images/148426957460814.png,images/148426957460815.png', '0', '2017-01-13', '酷竞体育', '19', '0', '0', '5'), ('237', '足球魔方', '足球魔方系魔方元倾力打造的中国最大的赛前大数据决策平台，使用独创的DeepCube人工智能算法，结合比赛基本面、球队技战术大数据、前方情报等多维度分析，提供前所未有的可视化信息和用户体验。', 'qr_code_icon/148426970114122.png', null, 'prod_icon/148426970114121.png', '', '17', ',2,5,6,9,17', 'images/148426970114123.png,images/148426970114124.png,images/148426970114125.png,images/148426970114126.png', '0', '2017-01-13', '魔方元科技', '19', '0', '0', '7'), ('238', '查菜谱', '随时随地查菜谱，吃自己爱吃的。', 'qr_code_icon/148427081361632.jpg', null, 'prod_icon/148427081361631.png', '', '15', ',6,9', 'images/148427081361633.png,images/148427081361634.png,images/148427081361635.jpg', '0', '2017-01-13', 'LosWish', '19', '0', '0', '0'), ('239', '精准天气预报', '包含国内外3000多个城市天气信息，采用国内外多家气象机构数据，空气质量指数、污染指数、温度趋势、pm2.5等更加丰富、精准天气信息！提供穿衣、洗车、紫外线、感冒、运动、旅游等生活指数，是您日常生活、出行旅游的必备小程序！', 'qr_code_icon/148427182121312.jpg', null, 'prod_icon/148427182121311.jpg', '', '10', ',6,7,9,11', 'images/148427182121313.jpg', '0', '2017-01-13', '九吨科技', '19', '0', '0', '10'), ('240', '天气e', '天气信息查询，未来15日内气象、温度、PM2.5等信息查询', 'qr_code_icon/148427190862117.jpg', null, 'prod_icon/148427190862116.png', '', '10', ',6,9', 'images/148427190862118.png,images/148427190862119.png', '0', '2017-01-13', '邓仔', '19', '0', '0', '7'), ('241', '华住酒店+', '华住酒店官方小程序，提供在线预订及咨询服务。', 'qr_code_icon/148427224781522.png', null, 'prod_icon/148427224783121.png', '', '2', ',7,9,11,12,15', 'images/148427224783123.png,images/148427224783124.png,images/148427224783125.png', '0', '2017-01-13', 'Seeyoon', '19', '0', '0', '7'), ('242', '同享好房', '《同享好房》根据购房者需求，智能推荐广州万科在售项目信息，同时直连万科三好顾问提供免费咨询、免费接送看房等服务!', 'qr_code_icon/148427243885032.jpg', null, 'prod_icon/148427243885031.jpg', '', '24', ',6,8,9,10,18', 'images/148427243885033.jpg,images/148427243885034.jpg,images/148427243885035.jpg,images/148427243885036.jpg', '0', '2017-01-13', '应龙悭臾', '19', '0', '0', '6'), ('243', '房天下买房', '房天下买房是国内领先的房地产门户房天下推出的一款购房应用,覆盖全国600多城市,囊括当地98%以上的新房、二手房、房价信息。', 'qr_code_icon/148427253500842.jpg', null, 'prod_icon/148427253500841.jpg', '', '24', ',6,8,9,12', 'images/148427253500843.jpg,images/148427253500844.jpg,images/148427253500845.png', '0', '2017-01-13', '房天下', '19', '0', '0', '12'), ('244', '摩拜单车', '扫码即可骑走的智能共享单车，路边任意合理区域内停车。', 'qr_code_icon/148427288715262.jpg', null, 'prod_icon/148427288715261.png', '', '4', ',3,6,7,11,17', 'images/148427288715263.png,images/148427288715264.png', '0', '2017-01-13', 'i.Juwin', '19', '3', '5', '26'), ('245', '蚂蚁天气预报', '最简洁精准的天气预报、空气质量', 'qr_code_icon/148427342003172.jpg', null, 'prod_icon/148427342003171.png', '', '10', ',6,9', 'images/148427342003173.jpg,images/148427342003174.jpg', '0', '2017-01-13', 'ants', '19', '0', '0', '4'), ('246', '城市天气预报', '城市天气预报是一款天气查询小程序，目前支持300个城市最近5天天气的查询。', 'qr_code_icon/148427352028277.jpg', null, 'prod_icon/148427352029776.jpg', '', '10', ',6,9', 'images/148427352029778.jpg', '0', '2017-01-13', '狼来了', '19', '0', '0', '0'), ('247', '朝夕万年历', '简洁优雅无广告的万年历，查农历、班休、宜忌、天气', 'qr_code_icon/148427374237782.jpg', null, 'prod_icon/148427392792581.jpg', '', '10', '6,9,10', 'images/148427374239283.png', '0', '2017-01-13', '小朝', '19', '0', '0', '4'), ('248', '30天天气预报', '提供各地30天内详细天气预报，让你可以提前计划和安排。', 'qr_code_icon/148427388744087.jpg', null, 'prod_icon/148427388744086.jpg', '', '10', ',6,7,11', 'images/148427388744088.png,images/148427388744089.png,images/148427388744090.png', '0', '2017-01-13', '乡居网', '19', '0', '0', '0'), ('249', '小病自助', '最专业的健康小症状自助工具。通过生活中的方法，解决健康小毛病。', 'qr_code_icon/148427657248812.jpg', null, 'prod_icon/148427657250411.jpg', '', '5', ',6,9,13', 'images/148427657250413.jpg,images/148427657250414.jpg,images/148427657250415.jpg,images/148427657250416.jpg', '0', '2017-01-13', 'Zhangjian', '19', '0', '0', '7');
INSERT INTO `app_product` VALUES ('250', '健康吃啥', '个性化推荐当令食物。根据身体状况，包含体质，慢性病，小症状，结合不同节气的智能推荐系统。', 'qr_code_icon/148427683670922.jpg', null, 'prod_icon/148427683670921.jpg', '', '5', ',6,9,13', 'images/148427683670923.jpg,images/148427683672524.jpg,images/148427683672525.jpg,images/148427683672526.jpg', '0', '2017-01-13', 'Zhangjian', '19', '0', '0', '0'), ('251', '明安益儿', '明安益儿是专为0-14岁儿童提供医疗健康服务的平台，提供各种健康检测工具，例如:视力检测。', 'qr_code_icon/148427697089732.jpg', null, 'prod_icon/148427697089731.jpg', '', '5', ',3,6,9,13', 'images/148427697089733.png,images/148427697089734.png,images/148427697089735.png,images/148427697089736.png', '0', '2017-01-13', '海long', '19', '0', '0', '4'), ('252', '经期月月记', '科学预测你的经期，从此告别大姨妈随时探访的尴尬。来月经，就用月月记~（产品截图部分是我们未来版本的预告图~敬请期待哦~）', 'qr_code_icon/148427863876742.jpg', null, 'prod_icon/148427863876741.png', '', '5', ',6,9,13', 'images/148427863876743.png,images/148427863878344.jpg,images/148427863878345.png', '0', '2017-01-13', '张怡', '19', '0', '0', '0'), ('253', '医生工具箱', '医生工具箱一款专门为医生量身打造的小程序，他能让您在微信里，轻松查看临床指南，浏览医学资讯，翻译医学词汇，检索专业文献，查询药品，分析化验单，完成医学计算，从而帮助您在科研及临床中，极大的提升工作效率', 'qr_code_icon/148427872097152.jpg', null, 'prod_icon/148427872098751.png', '', '5', ',6,13', 'images/148427872098753.png', '0', '2017-01-13', 'seven', '19', '0', '0', '0'), ('254', '好药师优选', '好药师是首批通过国家药监局认证的网上药店。好药师优选是好药师官方认证小程序，帮您放心购药，便捷寻药，特价促销，健康咨询。', 'qr_code_icon/148427894322262.jpg', null, 'prod_icon/148427894322261.jpg', '', '5', ',12,13,15', 'images/148427894322263.png,images/148427894322264.jpg,images/148427894322265.jpg,images/148427894322266.jpg', '0', '2017-01-13', '百慕古杜', '19', '0', '0', '0'), ('255', '数胎动', '一款极简的胎动计数器，怀孕期准妈妈必备的胎动记录工具。', 'qr_code_icon/148427902816072.jpg', null, 'prod_icon/148427902816071.png', '', '5', ',6,9,13', 'images/148427902816073.png,images/148427902816074.png', '0', '2017-01-13', '翼帆网络', '19', '0', '0', '0'), ('256', '药代通', '药代通医药营销众包服务平台', 'qr_code_icon/148427916748982.jpg', null, 'prod_icon/148427916748981.jpg', '', '5', ',13', 'images/148427916748984.jpg,images/148427916748985.jpg,images/148427916748986.jpg,images/148427916748987.jpg', '0', '2017-01-13', '药代通', '19', '0', '0', '1'), ('257', '药顾问 ', '为用户提供问药、找药和用药管理服务', 'qr_code_icon/148427925791212.jpg', null, 'prod_icon/148427925791211.jpg', '', '5', ',10,13', 'images/148427925791213.jpg,images/148427925791214.png,images/148427925791215.png', '0', '2017-01-13', '沫', '19', '0', '0', '2'), ('262', '表情集市', '这是你用了就离不开的表情小程序，收藏必备！各种聊天表情、专属红人表情、表情法力无边，污力淘淘；还能制作表情，让表情更具专属性！', 'qr_code_icon/148452980046812.jpg', null, 'prod_icon/148452980048411.png', '', '18', '6,9,10,18', 'images/148452980048413.jpg,images/148452980048414.jpg,images/148452980048415.jpg,images/148452980048416.jpg', '0', '2017-01-16', '九吨科技', '19', '5', '7', '49'), ('263', '嗨图 ', '微信制作专属表情包，蓝色大海的传说、鬼怪、网络热图....海量素材只要你想的到的全都有，一键换字炒鸡方便！斗图、发朋友圈装x，你逗逼道路上的神助攻get√', 'qr_code_icon/148452998851722.jpg', null, 'prod_icon/148452998851721.png', '', '18', ',5,6,9,18', 'images/148452998851723.png,images/148452998851724.png,images/148452998851725.png,images/148452998851726.png', '0', '2017-01-16', '-Fionaaa', '19', '4', '8', '19'), ('264', '斗图表情包神器', '斗图表情包 - 轻松制作最硬最low最抢眼的表情包。使用斗图表情包神器，斗图永远不会输。Gif 动效 搞笑 趣味 娱乐都不能少。', 'qr_code_icon/148453012480032.png', null, 'prod_icon/148453012480031.png', '', '18', ',6,9,18', 'images/148453012480033.png', '0', '2017-01-16', '重庆七步科技有限公司', '19', '4', '2', '13'), ('265', '找图神器', '斗图表情、明星美女、装B配图、唯美壁纸、海量高清图片免费下载，麻麻再也不用担心我找不到好图片了！', 'qr_code_icon/148453023130242.jpg', null, 'prod_icon/148453023130241.png', '', '18', ',5', 'images/148453023130243.png,images/148453023130244.png,images/148453023130245.png,images/148453023130246.png', '0', '2017-01-16', '7', '19', '4', '2', '10'), ('266', '大脑急转弯', '地球人都喜欢的休闲益智类游戏', 'qr_code_icon/148453035105352.jpg', null, 'prod_icon/148453035105351.jpg', '', '19', ',5', 'images/148453035105353.png,images/148453035105354.png,images/148453035105355.png', '0', '2017-01-16', '朱叶', '19', '4', '1', '7'), ('267', '芒果FUN', '芒果FUN是湖南卫视旗下，芒果互娱开发和运营的一款以湖南卫视节目IP为主的游戏、互动娱乐移动端产品。', 'qr_code_icon/148453048908662.jpg', null, 'prod_icon/148453048908661.jpg', '', '19', ',5,6', 'images/148453048908663.jpg,images/148453048908664.jpg,images/148453048908665.jpg', '0', '2017-01-16', ' 白牙', '19', '0', '0', '5'), ('268', '护眼宝+', '跟小护士做护眼操，3分钟消除疲劳', 'qr_code_icon/148453155277212.jpg', null, 'prod_icon/148453155278711.png', '', '5', ',3,6,9,13', 'images/148453155278713.jpg,images/148453155278714.jpg,images/148453155278715.jpg', '0', '2017-01-16', ' 护眼宝', '19', '3', '3', '9'), ('269', '四川大学华西第二医院', '跟小护士做护眼操，3分钟消除疲劳', 'qr_code_icon/148453208415412.jpg', null, 'prod_icon/148453208415411.jpg', '', '5', ',3,6,13', 'images/148453208415413.png,images/148453208415414.png', '0', '2017-01-16', '医生', '19', '0', '0', '3'), ('270', '娱票儿+', '娱票儿小程序，是 “微信钱包电影演出票” 官方应用。为你打通电影、演出、赛事一站式购票，购票更快更优惠', 'qr_code_icon/148453227729722.jpg', null, 'prod_icon/148453227729721.jpg', '', '12', ',6,9,12', 'images/148453227729723.jpg,images/148453227729724.jpg,images/148453227729725.jpg', '0', '2017-01-16', ' yuchen', '19', '0', '0', '7'), ('271', '小小票儿 ', '小小票儿是一个发现和参与活动的小程序。在这里你可以发现有趣的城市活动，分享给小伙伴，邀请他们参加，还可以扫码购票，二维码签到。', 'qr_code_icon/148453259806632.jpg', null, 'prod_icon/148453259806631.png', '', '12', ',9', 'images/148453259806633.png,images/148453259806634.png,images/148453259806635.png,images/148453259806637.png', '0', '2017-01-16', 'TinyGroup', '19', '0', '0', '2'), ('272', '火车票机票 ', '提供火车票、机票、酒店的产品预订，秉着用户第一的理念，能快速、便捷地完成预订的同时，也能享受全面、优质的售后服务，让您出行无忧，快乐每一程~', 'qr_code_icon/148453272858442.jpg', null, 'prod_icon/148453272861541.png', '', '4', ',7,9,11', 'images/148453272861543.jpg,images/148453272861544.jpg,images/148453272861545.jpg,images/148453272861546.jpg', '0', '2017-01-16', '998571', '19', '0', '0', '1'), ('273', '减脂助手', '减脂助手帮您快速查询食物的热量（卡路里），脂肪，蛋白质含量，微量元素等基础信息，帮您快速制定食谱，有效减脂。', 'qr_code_icon/148453446982712.jpg', null, 'prod_icon/148453446982711.jpg', '', '5', '6,9', 'images/148453446982713.jpg,images/148453446982714.jpg,images/148453446982715.jpg', '0', '2017-01-16', ' Zakk', '19', '4', '2', '16'), ('274', '鹿课堂手工教程 ', '鹿课堂是为热爱生活的人提供教学课程的社区。 我们拥有大量海内外布艺、饰品、旧物改造等优秀的手工作品教程，也有超多的家常菜、日式料理、洋快餐等厨艺教程。你可以轻松地浏览和查看，并且分享给你的好友。 鹿课堂力图打造成中国最好的互动社区，无论你是手工达人、料理大师、美容高手还是生活小窍门专家，在这里都可以找到志同道合的朋友。你也可以获取各种图文并茂的教程，享受自己动手带来的美好生活。', 'qr_code_icon/148453455812622.jpg', null, 'prod_icon/148453455814221.png', '', '15', ',5,9', 'images/148453455814223.png,images/148453455814224.png', '0', '2017-01-16', 'zzk', '19', '0', '0', '0'), ('275', '易菜谱 ', '指尖上的美食菜谱，为各位美食爱好量身定制的微信小程序。', 'qr_code_icon/148453469677232.jpg', null, 'prod_icon/148453469677231.png', '', '15', ',5,6,9', 'images/148453469677233.png,images/148453469677234.png,images/148453469677235.png,images/148453469677236.png', '0', '2017-01-16', '三里文化', '19', '5', '2', '5'), ('276', '斗图表情助手 ', '斗图表情助手 - 这里有最新最抢眼的表情包，使用斗图表情助手，风趣幽默、个性化，由你来做主。', 'qr_code_icon/148454948543512.jpg', null, 'prod_icon/148454948543511.jpg', '', '18', ',5,6,9,10,18', 'images/148454948543513.jpg,images/148454948543514.jpg,images/148454948543515.jpg', '0', '2017-01-16', '爱美互动', '19', '0', '0', '9'), ('277', '菜谱儿 ', '每天给您提供最新最热的菜谱.以及最全的菜谱大全. 菜谱儿,您身边的做菜助手', 'qr_code_icon/148454972825422.jpg', null, 'prod_icon/148454972825421.jpg', '', '15', ',6,9,10', 'images/148454972825424.jpg,images/148454972825425.jpg', '0', '2017-01-16', '长沙小雨网络科技', '19', '5', '1', '9'), ('278', '小表情 ', '发现、搜索全网表情图片', 'qr_code_icon/148454996672912.jpg', null, 'prod_icon/148454996672911.jpg', '', '18', ',5,6,9,18', 'images/148454996672913.png', '0', '2017-01-16', '江宇航', '19', '0', '0', '2'), ('279', '表情搜搜 ', '最接地气的表情搜索！聊天斗图就用表情搜搜！', 'qr_code_icon/148455005954322.jpg', null, 'prod_icon/148455005954321.png', '', '18', ',5,6,18', 'images/148455005954323.png,images/148455005954324.png,images/148455005954325.png,images/148455005954326.png', '0', '2017-01-16', '程序员姐姐', '19', '0', '0', '4'), ('280', '玩乐小帮手 ', '互动吧是最大的活动平台，共有5000万注册用户，同时在线活动近20万个，“玩乐小帮手”是互动吧官方微信小程序，品类覆盖亲子、手工、运动、娱乐、派对、培训、互联网等，通过这些精彩的活动，互动吧能让你发现更美好的生活方式！', 'qr_code_icon/148455057605732.jpg', null, 'prod_icon/148455057605731.png', '', '23', '6,9,18', 'images/148455057605733.png,images/148455057605734.png,images/148455057605735.png,images/148455057605736.png', '0', '2017-01-16', '互动吧', '19', '0', '0', '3'), ('281', '拇指快充 ', '互动吧是最大的活动平台，共有5000万注册用户，同时在线活动近20万个，“互动吧精选”是互动吧官方微信小程序，品类覆盖亲子、手工、运动、娱乐、派对、培训、互联网等，通过这些精彩的活动，互动吧能让你发现更美好的生活方式！', 'qr_code_icon/148455076696842.jpg', null, 'prod_icon/148455076696841.png', '', '7', ',6,9,12,15,18', 'images/148455076696843.png,images/148455076696844.png,images/148455076696845.png,images/148455076696846.png', '0', '2017-01-16', '冬未至', '19', '0', '0', '2'), ('282', '企鹅电竞+ ', '企鹅电竞是腾讯旗下的移动电竞内容平台，为玩家提供移动电竞的一站式体验，手游赛事、直播、视频、礼包内容应有尽有。', 'qr_code_icon/148455096492652.jpg', null, 'prod_icon/148455096492651.png', '', '14', ',5,18', 'images/148455096492653.jpg,images/148455096492654.jpg,images/148455096492655.jpg', '0', '2017-01-16', 'hongwei', '19', '0', '0', '4'), ('283', '简爱找对象 ', '真实的单身交友信息发布平台，提供高质量的同城异性，恋爱顾问人工服务，真正帮您解决找对象难题', 'qr_code_icon/148455104463162.jpg', null, 'prod_icon/148455104463161.jpg', '', '23', ',6,9,18', 'images/148455104463163.jpg', '0', '2017-01-16', '简爱', '19', '0', '0', '1'), ('284', '健身之家网 ', '健身之家是一个健身朋友互动交流的健身类平台，这里有完备的肌肉网络体系、专业的健身计划、详细的增肌减脂教程。', 'qr_code_icon/148455118726072.jpg', null, 'prod_icon/148455118726061.png', '', '17', ',6,9,17,18', 'images/148455118726073.png,images/148455118726074.png,images/148455118726075.png,images/148455118726076.png', '0', '2017-01-16', '健身之家', '19', '0', '0', '3'), ('285', '吉他课 ', '一款提供免费名师吉他课程的小程序', 'qr_code_icon/148455134979582.jpg', null, 'prod_icon/148455134979581.jpg', '', '8', ',4,6,18', 'images/148455134979583.jpg,images/148455134979584.jpg,images/148455134979585.jpg', '0', '2017-01-16', '蝌蚪课', '19', '0', '0', '3'), ('286', '群码 ', '上传分享群，发现更多有趣的群', 'qr_code_icon/14845514977522.jpg', null, 'prod_icon/148455149775211.jpg', '', '23', '6,18', 'images/148455149775213.png,images/148455149775214.jpg,images/148455149775215.jpg', '0', '2017-01-16', '青石板木', '19', '0', '0', '6'), ('287', '腾讯投票 ', '腾讯投票是一款由腾讯官方开发的微信投票工具，可以快速创建并分享投票到微信群和好友，实时显示投票结果，最好用的投票小程序，吃啥，玩啥，喜欢啥，大家说了算。', 'qr_code_icon/148455202609422.jpg', null, 'prod_icon/148455202609421.jpg', '', '23', '6,18', 'images/148455202609423.jpg,images/148455202609424.jpg,images/148455202609425.jpg,images/148455202609426.jpg', '0', '2017-01-16', '腾讯', '19', '0', '0', '4'), ('288', '群统计 ', '群统计是一款微信投票工具。使用它你可以便捷地发起投票，参与投票，分享投票。', 'qr_code_icon/148455211695632.jpg', null, 'prod_icon/148455211697131.png', '', '23', '6,18', 'images/148455211697133.png,images/148455211697134.png,images/148455211697135.png,images/148455211697136.png', '0', '2017-01-16', '诗书塞外', '19', '0', '0', '4'), ('289', '群约助手 ', '开会、组局、活动报名神器 还在群里用人名接龙组织活动？快来试试群约助手小程序！', 'qr_code_icon/148455220377042.jpg', null, 'prod_icon/148455220377041.jpg', '', '23', '2,6,9,18', 'images/148455220377043.png,images/148455220377044.png', '0', '2017-01-16', '小朝', '19', '0', '0', '0'), ('290', '美美买车＋ ', '美美买车是中国最专业的体验式汽车电商平台，汽车电商创新模式的引航者，为用户提供完美的线上购车体验。', 'qr_code_icon/148455234532152.jpg', null, 'prod_icon/148455234532151.jpg', '', '3', '2,6,9,12,18', 'images/148455234532153.png,images/148455234533654.png,images/148455234533655.png', '0', '2017-01-16', '唐柏平', '19', '0', '0', '2'), ('291', '八字历书 ', '八字历书为您提供祈福、纳财、嫁娶等吉日查询服务。以及每日宜忌、诸神方位灯信息，并编制出了具有特色的通胜模式日历，以便查看。', 'qr_code_icon/148455244710562.jpg', null, 'prod_icon/148455244710561.png', '', '7', ',6,9,18', 'images/148455244710563.jpg,images/148455244710564.jpg,images/148455244710565.jpg', '0', '2017-01-16', '易奇八字', '19', '0', '0', '0'), ('292', 'IT007论坛 ', '云南生活社区', 'qr_code_icon/148455267567372.jpg', null, 'prod_icon/148455267568971.png', '', '23', ',9,18', 'images/148455267568973.png,images/148455267568974.png,images/148455267568975.png,images/148455267568976.png', '0', '2017-01-16', '钱岗岗岗岗', '19', '0', '0', '1'), ('293', '铃声助手 ', '铃声助手，手机铃声最热排行榜，精选铃声大全，好用的铃声同步设置助手！支持中国移动 中国联通 中国电信三网设置彩铃。 【海量曲库】 500万首铃声实时更新，网罗分享量超高的铃声，汇总个性又流行的彩铃； 【语音搜铃】超好用的铃声搜索功能，哼节奏、说歌名、报歌手，精准定位你想要的铃声；只有你想不到的铃声，没有你找不到的铃声，就是这么任性！ 【一键设置】来电铃声、短信、闹铃一键设置，操作简单，提供个性化彩铃创作功能，不服来战！ 【无损音质】无损音质，音效调节，给你完美铃声体验。', 'qr_code_icon/148455281409882.jpg', null, 'prod_icon/148455281411381.png', '', '21', ',5,6,9,10,18', 'images/148455281411383.png,images/148455281411384.png,images/148455281411385.png,images/148455281411386.png', '0', '2017-01-16', '七七', '19', '0', '0', '2'), ('294', '技能街名录 ', '技能街名录 是一个技能共享平台。 在这里，你可以了解更多技能人、技能，学习或交换你喜欢的技能。 技能街，让你我更有价值。', 'qr_code_icon/148455310003992.jpg', null, 'prod_icon/148455310003991.png', '', '23', ',6,9,18', 'images/148455310003993.png,images/148455310003994.png,images/148455310003995.png', '0', '2017-01-16', '技能街官方客服小能猫', '19', '0', '0', '0'), ('295', '恋人清单', '恋人清单为情侣们提供两人间的私密清单，帮你规划好恋人必做的99件事，将你们美好的爱情记录其中~', 'qr_code_icon/148455493717212.jpg', null, 'prod_icon/148455493717211.jpg', '', '23', '5,6,18', 'images/148455493717213.png,images/148455493717214.png,images/148455493717215.png,images/148455493717216.png', '0', '2017-01-16', '阿哲', '19', '0', '0', '0'), ('296', '艺术签名助手 ', '集合多位书法艺术大家于一体,提供多达三十多种签名样式的艺术签名软件。展现了中华五千年书法艺术的魅力,并融合了各个时期的著名书法家的艺术风格,使每一个签名都充满了艺术表现力。', 'qr_code_icon/148455574272912.jpg', null, 'prod_icon/148455574274411.png', '', '7', ',6,9,18', 'images/148455574274413.jpg', '0', '2017-01-16', '九吨科技', '19', '0', '0', '10'), ('297', '群幂群插件 ', '群幂群插件是一款群应用场景的群工具集．针对微信群主在微信群里各种细化场景提供解决工具．推出群投票和群通知功能．可发起投票，收集群友意见；发布重要通知，触达所有群成员，随时查收通知结果．', 'qr_code_icon/148455617289122.jpg', null, 'prod_icon/148455617290621.png', '', '23', ',6,18', 'images/148455617290623.png', '0', '2017-01-16', '群幂群插件', '19', '0', '0', '0'), ('298', '博卡名片王 ', '微信首个名片类小程序。 目前是微信内唯一 一个名片管理类小程序。在不占用任何手机空间的前提下，整合了名片扫描识别、智能搜索、无限派发名片、企业信息透视等功能。 - 四重 OCR 引擎智能选择，精准识别名片信息 - 名片三秒极速扫描，收纳名片与微信绑定，告别第三方 app - 手机空间零占用，从此告别卡慢急 - 独家企业信息透视', 'qr_code_icon/148455686216232.jpg', null, 'prod_icon/148455686216231.png', '', '7', ',1,2,6,10,18', 'images/148455686216233.jpg,images/148455686216234.jpg,images/148455686216235.jpg,images/148455686216236.jpg', '0', '2017-01-16', '雪藏', '19', '0', '0', '2'), ('299', '全球职场通讯录', '职场通讯从此畅通无阻', 'qr_code_icon/148455699202242.png', null, 'prod_icon/148455699202241.png', '', '7', '6,18', 'images/148455699202243.png', '0', '2017-01-16', 'taou', '19', '0', '0', '2'), ('300', '附近无秘 ', '你身边的私密社区', 'qr_code_icon/148455724822752.jpg', null, 'prod_icon/148455724822751.png', '', '23', ',18', 'images/148455724822753.png', '0', '2017-01-16', '附近无秘', '19', '0', '0', '2'), ('301', '朋友相册 ', '还在用qq相册？该长大了 朋友相册，和朋友一起传照片。', 'qr_code_icon/148455757689062.png', null, 'prod_icon/148455757689061.png', '', '6', ',6,9,18', 'images/148455757689063.png,images/148455757689064.png,images/148455757689065.png,images/148455757689066.png', '0', '2017-01-16', 'App Hugh', '19', '4', '4', '12'), ('302', 'BlackWeed黑果', '黑果官网TheBlackWeed.com，为乐手和乐迷提供专业的圈内服♂务。 请在微信直接搜索：“BlackWeed”。', 'qr_code_icon/148455769742472.jpg', null, 'prod_icon/148455769744071.jpg', '', '21', '2,5,6,9,18', 'images/148455769744073.jpg,images/148455769744074.jpg,images/148455769744075.jpg', '0', '2017-01-16', '✿', '19', '0', '0', '0'), ('303', '社交名片 ', '基于小程序的名片录入与分享工具，解决工作场景忘带名片的尴尬，快速实现名片录入、智能标签、分组、分享名片等功能。', 'qr_code_icon/148455838858282.jpg', null, 'prod_icon/148455838859881.png', '', '7', ',2,6,12,18', 'images/148455838859883.png', '0', '2017-01-16', '畅移信息', '19', '0', '0', '3'), ('304', 'IUMeeting活动 ', '把流程和繁琐交给程序，让每次活动都激动人心，跟所有参加活动的伙伴欢乐互动。活动欢愉，人脉累积，就在IUMeeting活动。', 'qr_code_icon/148455859983892.png', null, 'prod_icon/148455859985391.png', '', '23', ',2,6,9,18', 'images/148455859985393.png,images/148455859985394.png,images/148455859985395.png,images/148455859985396.png', '0', '2017-01-16', 'IUMeeting', '19', '0', '0', '0'), ('305', '十点读书', '深夜十点，陪你读书，一种美好的生活方式。分享好书/故事/电台/美学。', 'qr_code_icon/148455908233512.jpg', null, 'prod_icon/148455908235011.jpg', '', '13', ',4,5,9,18', 'images/148455908235013.jpg,images/148455908235014.jpg,images/148455908235015.jpg', '0', '2017-01-16', 'wolfme', '19', '0', '0', '0'), ('306', '买一只 ', '放心买宠物，就找『买1只』（1）卖家认证（2）担保交易（3）30天保障（4）健康保险（5）分期付款（6）大礼包（7)养宠顾问', 'qr_code_icon/148455968641322.jpg', null, 'prod_icon/148455968641321.jpg', '', '3', ',9,10,12,15,18', 'images/148455968641323.jpg,images/148455968641324.jpg,images/148455968641325.jpg,images/148455968641326.jpg', '0', '2017-01-16', 'charlie', '19', '0', '0', '0'), ('307', '小区拼团号 ', '和小区邻居好友一起拼团，优质食材零食，产地直发到家。优质好货，拼团更省钱，快来一起拼吧', 'qr_code_icon/148455984227632.jpg', null, 'prod_icon/148455984227631.jpg', '', '3', ',6,9,12,15,18', 'images/148455984227633.jpg,images/148455984227634.jpg,images/148455984227635.jpg,images/148455984227636.jpg', '0', '2017-01-16', 'Feng', '19', '0', '0', '0'), ('309', '忆年共享相册 ', '忆年共享空间，让小圈子共享照片更方便。为亲密小圈子提供快速交换和共享照片的服务，让我们的照片在一起。 照片只有进入空间的小伙伴才能看到，并且云端永久储存在专属于你们的私密小空间。忆年想用一个个小而美的私密空间，为你记录所有值得分享的时刻。', 'qr_code_icon/148461412803112.jpg', null, 'prod_icon/148461412806211.png', '', '6', ',5,6,9,14,18', 'images/148461412806213.jpg,images/148461412806214.jpg,images/148461412806215.png,images/148461412806216.jpg', '0', '2017-01-17', '忆年', '19', '3', '7', '82'), ('310', '篱笆闲聊 ', '篱笆闲聊 - 伴你经历人生中的每个重要时刻！年轻家庭，生活消费社区。', 'qr_code_icon/148461420009422.jpg', null, 'prod_icon/148461420011021.png', '', '23', ',18', 'images/148461420011023.jpg,images/148461420011024.jpg,images/148461420011025.jpg,images/148461420011026.jpg', '0', '2017-01-17', '甜菜冬瓜', '19', '3', '14', '137'), ('311', '快趣投', '投票召集聚会，定日子，上哪吃，活动评选。大事小事，一票敲定！来自公众号万言趣投，快趣投！', 'qr_code_icon/148461451211432.jpg', null, 'prod_icon/148461451211431.png', '', '23', ',6,9,18', 'images/148461451211433.jpg,images/148461451211434.jpg,images/148461451211435.jpg,images/148461451211436.jpg', '0', '2017-01-17', '快趣投', '19', '4', '4', '43'), ('312', '查美妆 ', '查美妆，由专注于美妆口碑查询与分享的闺蜜美妆开发。依托于亚洲最大化妆品库和最真实用户口碑，买化妆品前查一查，少花冤枉钱。', 'qr_code_icon/148461480686742.jpg', null, 'prod_icon/148461480686741.png', '', '16', ',2,6,9,10,18', 'images/148461480686743.png', '0', '2017-01-17', '爱阳光', '19', '5', '3', '14'), ('313', '天天跟我买', '天天跟我买，提供海内外好货专业代下单服务，现在就体验省钱、省事、不省品质的购物享受吧！', 'qr_code_icon/148461502791762.jpg', null, 'prod_icon/148461502791761.jpg', '', '23', ',6,9,12,18', 'images/148461502791763.jpg,images/148461502791764.png,images/148461502791765.png', '0', '2017-01-17', 'iscca', '19', '5', '3', '12'), ('314', '春秋航空特价机票', '春秋航空特价机票官方购票小程序，价格品质保证，实时出票，1元起机票让你玩到爽。 打开微信【发现】-【小程序】-搜索【春秋航空特价机票】体验或者登陆知晓程序PC端扫码体验', 'qr_code_icon/148496225030212.jpg', 'mp_code_icon/1484998104158t01750a00610acf3ba0.jpg', 'prod_icon/148496225030211.jpg', '', '12', '6,7,9,11,12', 'images/148496225030213.jpg,images/148496225030214.jpg,images/148496225030215.jpg,images/148496225030216.jpg', '0', '2017-01-21', '春秋航空', '19', '5', '1', '239'), ('315', '车来了', '快速查询公交信息，精准获得到站时间！', 'qr_code_icon/148496255967922.jpg', null, 'prod_icon/148496255967921.jpg', '', '4', ',6,7', 'images/148496255967923.jpg,images/148496255967924.jpg', '0', '2017-01-21', '车来了', '19', '5', '3', '174'), ('316', '查地铁 ', '免流量查询各大城市地铁线路、出入口、运营时间及周边吃喝玩乐信息，您的地铁生活指南', 'qr_code_icon/148496271655532.jpg', null, 'prod_icon/148496271655531.jpg', '', '4', ',6,7,9,11', 'images/148496271655533.png,images/148496271655534.png,images/148496271655535.png,images/148496271655536.png', '0', '2017-01-21', '国家免检好孩子', '19', '0', '0', '87'), ('317', '飞常准查航班 ', '飞常准小程序清爽来袭，精准航班信息轻松查，值机选座快人一步，怕延误就用飞常准！', 'qr_code_icon/148496283118142.jpg', 'mp_code_icon/1484998850954t01a597781cce65397d.jpg', 'prod_icon/148496283118141.jpg', '', '4', '6,7,9,11', 'images/148496283118143.png,images/148496283118144.png,images/148496283118145.png,images/148496283118146.png', '0', '2017-01-21', '尚飞', '19', '4', '1', '52'), ('318', '招行信用卡 ', '招商银行信用卡小程序，向用户提供查账、查额、查积分的功能，可以快速查看已出账单明细和未出账单明细。', 'qr_code_icon/148496316538652.jpg', null, 'prod_icon/148496316538651.png', '', '11', ',1,6,9', 'images/148496316538653.jpg,images/148496316538654.jpg,images/148496316538655.jpg,images/148496316538656.jpg', '0', '2017-01-21', '7FF', '19', '0', '0', '46'), ('319', '南方基金微理财 ', '南方基金小程序，集现金管理、基金交易、净值查询等多种功能于一体，致力于做您最贴心的掌上财富管家，让您随时随地轻松理财！', 'qr_code_icon/148496333005962.jpg', null, 'prod_icon/148496333005961.jpg', '', '11', ',1', 'images/148496333005963.png,images/148496333005964.png,images/148496333005965.png,images/148496333005966.png', '0', '2017-01-21', 'movieatravelove', '19', '0', '0', '23'), ('320', 'FellowPlus 创投数据库 ', '用数据读懂早期投资。覆盖全网 28 万 + 互联网项目，通过多维、结构化的方式展示项目数据，让您准确、及时获取行业和项目信息。', 'qr_code_icon/148496354787372.jpg', null, 'prod_icon/148496354787371.jpg', '', '11', ',1,6,10', 'images/148496354787373.png,images/148496354787374.png,images/148496354787375.png,images/148496354787376.png', '0', '2017-01-21', '李奶油', '19', '0', '0', '21'), ('321', '解忧室 ', '用手机遇到奇怪的问题不知道怎么办？我来帮你解答。', 'qr_code_icon/148496373643682.jpg', null, 'prod_icon/148496373643681.jpg', '', '7', ',6,10', 'images/148496373643683.png,images/148496373643684.png,images/148496373643685.png,images/148496373643686.png', '0', '2017-01-21', 'ifanr', '19', '5', '1', '33'), ('322', '黄历万年历 ', '黄历万年历为您提供祈福、纳财、嫁娶等吉日查询服务。以及每日宜忌、诸神方位灯信息，并编制出了具有特色的通胜模式日历，以便查看。', 'qr_code_icon/148496387890692.png', null, 'prod_icon/148496387890691.jpg', '', '7', ',6', 'images/148496387890693.jpg,images/148496387890694.jpg,images/148496387890695.jpg', '0', '2017-01-21', '易奇八字', '19', '4', '1', '59'), ('323', '换算 ', '一款功能强大的国内外计量单位相互快速换算软件。内容包括：长度，功、能和热量，功率计量单位，面积，体积和容量计量单位等。', 'qr_code_icon/148496402946912.jpg', null, 'prod_icon/148496402946911.png', '', '7', ',6', 'images/148496402946913.png,images/148496402946914.png,images/148496402946915.png,images/148496402946916.png', '0', '2017-01-21', '翼帆网络', '19', '0', '0', '35'), ('324', '亲戚关系', '亲戚关系是一款最全面的中国亲戚关系计算器，走亲访友，逢年过节必备神器，避免叫错、不会叫亲戚的尴尬，人人必备亲戚关系工具。', 'qr_code_icon/148496416989222.jpg', null, 'prod_icon/148496416989221.png', '', '7', ',6,9', 'images/148496416989223.jpg,images/148496416989224.jpg,images/148496416989225.jpg,images/148496416989226.jpg', '0', '2017-01-21', '我来也', '19', '0', '0', '34'), ('325', '腾讯加油卡服务 ', '提供括中石化、中石油、中海油等加油卡充值服务、余额查询等服务。', 'qr_code_icon/148496427772132.jpg', null, 'prod_icon/148496427772131.png', '', '7', ',6,7,9', 'images/148496427772133.jpg,images/148496427772134.jpg,images/148496427772135.jpg,images/148496427772136.jpg', '0', '2017-01-21', 'PrinCe', '19', '4', '1', '20'), ('326', '朝夕日历Pro ', '朝夕日历—智能的时间助理；长按添加按钮可以语音添加日程；提供列表视图；帮助您简简单单地安排时间，发现生活~', 'qr_code_icon/148496444283142.jpg', null, 'prod_icon/148496444283141.jpg', '', '7', ',6,10', 'images/148496444283143.png,images/148496444283144.png,images/148496444283145.png,images/148496444283146.png', '0', '2017-01-21', '小夕', '19', '0', '0', '14'), ('327', '印象笔记微清单 ', '印象笔记微清单帮你随时随地创建各种小清单。从购物、美食、旅行到工作学习，微清单都能助你一臂之力。', 'qr_code_icon/148496457462952.jpg', null, 'prod_icon/148496457462952.jpg', '', '7', ',2,6,9,10,15', 'images/148496457462953.png,images/148496457462954.png,images/148496457462955.png,images/148496457462956.png', '0', '2017-01-21', '印象笔记', '19', '0', '0', '14'), ('328', '蚂蚁待办 ', '最简洁的待办、提醒', 'qr_code_icon/148496472122862.jpg', null, 'prod_icon/148496472122861.png', '', '7', ',6', 'images/148496472122863.jpg,images/148496472122864.jpg,images/148496472122865.jpg,images/148496472122866.jpg', '0', '2017-01-21', 'ants', '19', '0', '0', '8'), ('329', '番茄闹钟 ', '微信上就能用的番茄闹钟，让你保持专注每个25分钟！ 最新版已经解决锁屏暂停计时的问题！', 'qr_code_icon/148496487096772.jpg', null, 'prod_icon/148496487096771.jpg', '', '7', ',6,10', 'images/148496487096773.png,images/148496487098274.png,images/148496487098275.png', '0', '2017-01-21', '小夕', '19', '4', '1', '26'), ('330', '易打卡', '简洁好用的打卡小程序，群友好友之间迅速打卡记录。', 'qr_code_icon/148496509352115.jpg', null, 'prod_icon/148496509352111.jpg', '', '7', ',6', 'images/148496509352112.jpg,images/148496509352113.jpg,images/148496509353614.jpg', '0', '2017-01-21', '易打卡', '19', '0', '0', '7'), ('331', '签到打卡 ', '为活动发起人提供创建、管理、组织签到打卡活动的工具', 'qr_code_icon/148496517696122.jpg', null, 'prod_icon/148496517696121.jpg', '', '7', ',6,9,18', 'images/148496517696123.png,images/148496517696124.png,images/148496517696125.png', '0', '2017-01-21', '朱叶', '19', '0', '0', '9'), ('332', '草料二维码', '使用这个小程序可方便快速生成或管理二维码', 'qr_code_icon/148496801698912.jpg', null, 'prod_icon/148496801698911.jpg', '', '7', ',2,6,9', 'images/148496801698913.jpg,images/148496801698914.jpg', '0', '2017-01-21', '草料二维码', '19', '0', '0', '13'), ('333', '高校图书馆查询 ', '提供了主要的高等院校的图书馆查询，包含了图书关键词查询，书目详情（馆藏地、状态）等服务。目前支持的高校在持续添加中...', 'qr_code_icon/148496832523222.jpg', null, 'prod_icon/148496832523221.png', '', '8', ',6', 'images/148496832523223.png,images/148496832523224.png,images/148496832523225.png,images/148496832523226.png', '0', '2017-01-21', '小日子先生', '19', '0', '0', '7'), ('334', '快递100⁺ ', '查快递，寄快递，上快递100', 'qr_code_icon/148496847036132.jpg', null, 'prod_icon/148496847037631.png', '', '9', ',6,9,12,16', 'images/148496847037633.png,images/148496847037634.png,images/148496847037635.png,images/148496847037636.png', '0', '2017-01-21', '快递100', '19', '0', '0', '19'), ('335', '今日头条lite', '今日头条小程序二维码是今日头条微信公众账号当中的今日头条小程序入口。今日头条作为目前最火的新闻应用，推出小程序是为了让大家更快更方便的了解全新的头条新闻，喜欢今日头条的朋友别忘了支持一下今日头条的官方小程序哦。\r\n　　今日头条通过对资讯在社交网站上的传播情况以及成千上万个网站的数据挖掘，智能地分析出每时每刻最热门最值得你知道的资讯。它能迅速解读你的兴趣DNA，无需复杂的选择的订阅，即会猜出你感兴趣的文章；而且你用得越多，“今日头条”就越懂你，你会得到你更喜欢的文章。', 'qr_code_icon/148496855950420171121421372193192411861580.jpg', 'mp_code_icon/1484997657962t01f944a0920882926c.jpg', 'prod_icon/1484968559504201711197476537536855205910_100_100.jpg', '', '13', '3,9', 'images/1484968559504201711197345426425744194810_600_566.jpg,images/1484968559504201711197450971970288638350_600_566.jpg', '0', '2017-01-21', '今日头条', '21', '0', '0', '22'), ('336', '云梦助眠引导 ', '动静科技（Soundario Inc.）出品的音频助眠应用“云梦”，是通往甜美梦境的声音向导，将帮助你快速入睡。 “云梦”可以使你保持作息规律，将生物钟调节到最合适状态，令生活工作增强动力，保持效率的同时心情舒畅。 每当你感到入睡困难时，你只需要启动“云梦”APP，就可以获得： ◇ 放松、和缓的睡眠引导，营造睡眠的心理舒适区，让您体会渐渐进入梦境中的美好过程。 ◇ 安全、舒适的内容，全部经过专业心理咨询顾问审议，严格遵循睡眠专业理论指导。 ◇ 温暖、平和的语音，由专业配音演员及广播主持人精心录制的人声。 ◇ 优秀音乐人专门制作的弛放氛围音乐，以及双通道采样撷取的山海间自然之声。 ◇ 顶尖音频编辑团队打造的混音，加强各频段声学效应的后期精良制作。 ◇ 通过云端下载，同步更新的声音情境。确保有充分的选择，常梦常新。', 'qr_code_icon/148496857317642.png', null, 'prod_icon/148496857317641.png', '', '5', ',5,9,13', 'images/148496857317643.jpg,images/148496857317644.jpg', '0', '2017-01-21', '帆野', '19', '0', '0', '5'), ('337', 'Flipboard日读', '每日为你提供『10个领域，10条热文』。在这里我们为你化繁为简，以少胜多。一手掌握最重要的领域资讯，读每日新闻，览天下精彩。', 'qr_code_icon/148496881175960009d0c1623a481471f3c80ec140821f6f4795d-59a9822638eaaf02e225022b5b5cb8d788fb9d9d.jpg', null, 'prod_icon/14849688117598ee5a5022aa45374b60589d641dbb731963d8395-ef0c2dae678bddf7195fa9c75af69982e85b1c9c.png', '', '13', ',5,9', 'images/1484968811759c722a7460f2c10a95c1eb1945d5fe76b04750188-5c20dcbcfbab07ab6c2df7e27444d5ac2afca569.png,images/1484968811759b7330d0fe9818e65c119e38042b87279569e5de3-bd473197c461193ea9b6d317f4c236910d065887.png,images/14849688117597eabc6d0ca521056d04e5f90ed988c266619c652-e3039f248dd555899a396179b51a05be377f9973.png,images/1484968811759291672c828df84d2a96c7d73c4e4aebbdc8211ed-278cadb5c5a600fd354bbb4a32acf34407bf98f0.png', '0', '2017-01-21', 'Flipboard中国', '21', '0', '0', '6'), ('338', '美柚App ', '姨妈来没来，下次几号来，打开美柚小程序，一查便知！精准的经期预测，贴心的经期知识，一款最懂女生的经期管理工具，让你遇见更美的自己。', 'qr_code_icon/148496881794752.jpg', null, 'prod_icon/148496881794751.png', '', '5', ',5,6,9,13', 'images/148496881794753.jpg,images/148496881794754.png,images/148496881794755.jpg', '0', '2017-01-21', '小柚子', '19', '0', '0', '11'), ('339', '小睡眠 ', '小睡眠，微信第一批小程序，爆款好评，首日70万+用户，3日100万+用户，数百家权威媒体和自媒体大号热力推荐！ 心潮小睡眠是一款睡前辅助小程序，数十种最纯粹的天然白噪音，帮你阻挡世界的嘈杂，营造完美氛围。今夜拥有小睡眠，梦里细雨微风、落叶飞雪…', 'qr_code_icon/148496894094962.png', null, 'prod_icon/148496894094961.png', '', '5', ',5,6,9,10,13', 'images/148496894096563.jpg,images/148496894096564.png,images/148496894096565.png,images/148496894096566.png', '0', '2017-01-21', '广州心与潮信息科技有限公司', '19', '0', '0', '11'), ('340', 'Qdaily（好奇心日报小程序）', '颜值最高的新闻小程序，目前微信只支持“二维码扫一扫”或“小程序搜索 Qdaily”，不能直接“识别图中二维码”。', 'qr_code_icon/14849690530452c1ef255047c940e427713ce3e3da062af600e5c-e802158a3de41fe3980f4fc9e1bcb89ab48aa621.jpg', 'mp_code_icon/14851348321481485134911(1.png', 'prod_icon/14849690530453eaeae57cdbbcad68d389251b11cae91b01481c0-59f4bc68aa37b095a17ba4ee86bd45f345aeff29.png', '', '13', '5,9', 'images/14849690530456be90c0682418906e2466979ff46c4994b92a00d-afaa5b65ee1281064a065af5327e51f7918aacfd.jpg,images/148496905304544850ed42b7926878dfd614ab949e48d63afa6b0-48bca9eccf5595b725b6b6c78bbb87523583efc8.jpg,images/148496905304517141816472333ab6646ae1e152943d46e0be4f5-7de9eb435923036a61374d279defb831ba627d4b.jpg,images/1484969053045fd90909fd4c742b1733658676f6556a5c96c889f-76c7420f923ab8392d9f94705964bd47c4317276.jpg', '0', '2017-01-21', '好奇心日报', '21', '0', '0', '2'), ('341', '得到 plus', '得到plus是罗辑思维团队出品的知识服务小程序，每天提供高质量的知识新闻和书籍精华，帮助用户缓解知识焦虑症。', 'qr_code_icon/14849692566742282cb21dc084bf503dc90d49dd8a9ec01c17568-f477e641215f59b3f25f479e649620541fe5af40.jpg', 'mp_code_icon/14851346073161485134681(1.png', 'prod_icon/1484969256674fac7cc3bda452ae2337bdc2eab0c652647d35a79-428010e3aaf2a974d1385bb05850d17c8b3303c0.png', '', '13', '5', 'images/148496925667421ae5d0358a57823556a922b10af59a6a121f52d-172a352c27cd4f1f953f95667d93cc9d4be69f7a.png,images/1484969256674200fad363557e3a0c55b6ab7a9f864fd53f0574b-53bb48f36f33f9d29dde576ffdd1fa6cb922d5bf.png,images/14849692566746448f46f8359f9004de4b1d47183878338e2a9cf-e4e8fa6f572583554ced81503175649017a4f058.png', '0', '2017-01-21', '快刀青衣', '21', '0', '0', '7'), ('342', '桔子创投内参', '桔子创投内参，是一款创业与投资的红宝书，汇集了每日创投领域最干货的文章。', 'qr_code_icon/14849694277400c8b5a321e5ed2ac409873f8e289b4417ce2733b-c17d0112c74b3ae8ab356bd86647b396f9fee7e4.jpg', null, 'prod_icon/14849694277405b72c94ccda850a81c46cc4d2050ae6f1699ad55-97657ec681835214ce7925f4412fbab6df1eca83.png', '', '11', ',5,6', 'images/148496942774091719739d10cfa768d67e3732d27cd1cc2a867cb-5383fd77aa35df53bc836a4f5ad5a4515cabf263.png,images/148496942774095449542879722b2378786dfaef4daeac6d1b6f8-e7e69acfd76bc10de09bc0bc7393fe128583df96.png', '0', '2017-01-21', 'Zealen', '21', '0', '0', '9'), ('343', '毒舌电影社区 ', '集影片推荐、影片信息查询和深度影评于一体的影片资讯小程序。想知道有哪些新电影资源，想知道有什么好电影，毒舌电影满足您。', 'qr_code_icon/148496945819472.jpg', null, 'prod_icon/148496945819471.jpg', '', '7', ',5,9', 'images/148496945819473.jpg,images/148496945819474.jpg,images/148496945819475.jpg,images/148496945819476.jpg', '0', '2017-01-21', '毒舌电影', '19', '0', '0', '4'), ('344', '轻芒杂志', '每个人都有兴趣，如果没有，就该培养一个。 超过 160 本精选兴趣杂志：涵盖家居、美食、护肤、艺文、宠物、运动、科技、旅行、手工等所有生活领域。从入门知识，到好物、配方和去处，每天更新适读好文章。还可以把你的兴趣告诉小花，它就能帮你定制一本自己的杂志。 简洁优美的笔记：在文章中发现别人留下的笔记、划下的重点，在分享的过程中发现更多乐趣。而只要轻松长按一段话或一张图，就可以方便添加你自己的笔记和摘录。 低密度排版：给生活足够的留白，希望你能每天轻松愉悦地打开。', 'qr_code_icon/1484969625947936584b3a7e0b77bc2bb5dfe6ee574f8388e9d81-46f6e4c14824c6c41acca7b472ce1c48b9f22a22.jpg', 'mp_code_icon/14851340763521485134146(1.png', 'prod_icon/1484969625947bd16c06e1a0a52c449af69494a8802765141b1de-33e0dc215d95fbabccc525ddf70a5ebad8fc9b0d.png', '', '13', '5,18', 'images/1484969625947a761788cdc029d0a9eb014e3f159368fbbc3b8d2-28a8b73dcc9fc87ba6ef3d96c3a018659e710e00.png,images/1484969625947a801bf44910b9c060043d92eaf53259def53ef1a-f8eacb9a73a7b200ba96e5b0588c59f271754f15.png,images/14849696259477c923ecebc86548953871223c4349f29286150e3-a0570065ba6787cdb37f670edf047a2cc486b563.png,images/148496962594791a9bd2b20507547015e7a4787f55ebdc9129d40-2318b9516d2ef056dfc4e0a70174ebb559224ccc.png', '0', '2017-01-21', '轻芒', '21', '0', '0', '9'), ('345', '豆瓣评分', '豆瓣评分提供最新的电影介绍及评论，包括上映影片的影讯查询。', 'qr_code_icon/148496964894712.jpg', null, 'prod_icon/148496964894711.jpg', '', '7', ',5', 'images/148496964894713.jpg,images/148496964894714.jpg', '0', '2017-01-21', '豆瓣', '19', '0', '0', '4'), ('346', '一首一首诗 ', '获奖应用“给孩子的诗”的小程序版本。 在这里，每天都能遇到一首新的诗歌，朗读，是和它们交朋友的最佳方式。用录音为诗歌注入你的元素，这是属于你独一无二的诗集。', 'qr_code_icon/148496996545322.jpg', null, 'prod_icon/148496996545321.jpg', '', '8', ',5,6', 'images/148496996546923.png', '0', '2017-01-21', '美丽阅读', '19', '0', '0', '6'), ('347', '腾讯视频', '腾讯视频的官方小程序版本，播放流畅。', 'qr_code_icon/148497024552131.png', 'mp_code_icon/1484998072689t0187592e04fca4633b.jpg', 'prod_icon/148497024553731.jpg', '', '14', '5,6', 'images/148497024553733.png,images/148497024553734.png,images/148497024553735.png', '0', '2017-01-21', '腾讯视频', '19', '0', '0', '10'), ('348', '开眼视频Eyepetizer ', '开眼视频，每天精彩短视频推荐。美食、运动、旅游视频', 'qr_code_icon/148497033849242.jpg', null, 'prod_icon/148497033849241.jpg', '', '14', ',5,6,11,17', 'images/148497033849243.jpg', '0', '2017-01-21', '开眼 Eyepetizer', '19', '0', '0', '7'), ('349', 'QQ阅读', 'QQ阅读小程序二维码是QQ阅读小程序在微信公众号QQ阅读官方的入口，经常喜欢看书的朋友们可以直接在微信中使用中的扫一扫功能扫一下QQ阅读小程序二维码就能直接QQ阅读小程序中！\r\n　　QQ阅读小程序有什么特色？\r\n　　1.使用QQ阅读小程序来看书可以节约升级空间内存！\r\n　　2.QQ阅读小程序不需要不断更新升级，只需要通过微信的小程勋端口进入就能直接使用！\r\n　　3.QQ阅读小程序进去之后直接有搜索栏目，搜索你想要看的书籍，还会有榜单推介各种各样的好书！\r\n　　如二维码扫不出，可以通过在微信小程序搜索“QQ阅读”找到QQ阅读”小程序。', 'qr_code_icon/148497061990320171121413545426425743184800.jpg', 'mp_code_icon/14851338147541485133862(1.png', 'prod_icon/14849706199192017112013316537536854295910_100_100.jpg', '', '13', '5,6', 'images/14849706199192017112013309860869188538250_600_566.jpg,images/14849706199192017112013302193192400850570_600_566.jpg', '0', '2017-01-21', 'QQ阅读', '21', '0', '0', '6'), ('350', '科技日历', '中关村在线出品，便于用户查询科技行业将来及过往新品发布会、行业展会、高端访谈信息，浏览最新科技资讯，翻看趣味科技老黄历。', 'qr_code_icon/1484970790922ceac96a08fb1b2caf2899b8639bc419bc8d14074-41952434d9467428bde6cfbd990bd17b4a53cdcf.jpg', null, 'prod_icon/1484970790922c39208330b5004724c88821f875c2f52aa2c9f24-cf4d17f012a8570a96fd7b29823ff3ffb400a06d.jpg', '', '13', ',5,10', 'images/148497079092293da3f00a9a0fdf6bde36a12d598546c36a1ff76-18086d37e09464a9f5a6f130d483c2c53c11e1a5.jpg,images/1484970790922687b6e8652efe2b57471ef1533e5f13cac434257-f4cdf9d95ba9ebd12833c9966a5673f887b9a780.jpg,images/1484970790922d54d32674301da67a2368219050920da42d5950b-80e098a8619ae448d0ce12047f0bdeccd2993231.jpg', '0', '2017-01-21', 'Felix', '21', '0', '0', '3'), ('351', '礼物挑选神器', '最用心的礼物挑选工具，汇集有调APP的品质好物，拒绝大街货，为你量身甄选精致礼物，找到最佳的送礼之选。', 'qr_code_icon/1484979256726offy6e-rdc.jpg', 'mp_code_icon/1485047989379qrcode_diaox2_1.jpg', 'prod_icon/14849792567269d60b40.png', '', '3', '12', 'images/14849792567264983e51.jpg,images/1484979256726a57a0a7.jpg,images/1484979256726fe79c1f.jpg,images/148497925672656cfb61.jpg', '0', '2017-01-21', '有调APP', '25', '0', '0', '7'), ('352', '腾讯周边', '正品周边商城，提供全面、实惠的企鹅形象周边、游戏动漫影视周边商品，以及其他服务等', 'qr_code_icon/148497943677720171102040506537536844294910.jpg', null, 'prod_icon/1484979436777023ffc9.jpg', '', '3', ',12', 'images/14849794367774b58cf7.jpg,images/148497943677726efd55.jpg,images/148497943677786e8085.jpg', '0', '2017-01-21', '贝勒爷', '25', '0', '0', '0'), ('353', '有赞精选', '专门帮你发现朋友圈里口碑好货和服务。', 'qr_code_icon/148497957627920171121714404315324633083700.jpg', 'mp_code_icon/1485048301199qrcode_youzanmall_1.jpg', 'prod_icon/1484979576279a45e61d.jpg', '', '3', '12', 'images/148497957627991d9edc.png,images/1484979576279ecd9c39.png,images/1484979576279402c629.jpg', '0', '2017-01-21', '有赞冷面', '25', '0', '0', '0'), ('354', '京东购物', '京东购物官方小程序，京东买买买更多样了。', 'qr_code_icon/148497971504814846351173355298.png', 'mp_code_icon/1485048388139qrcode_JD_1.jpg', 'prod_icon/14849797150487f21954.jpg', '', '3', '12,15', 'images/14849797150483b11e12.jpg', '0', '2017-01-21', 'minapp.com', '25', '0', '0', '15'), ('355', '值得买购物攻略', '汇总什么值得买最有价值的购物攻略：有科技大神玩3C的数码心得，有白富美对护肤品的深度测评，更有老司机分享的各国海淘经验。', 'qr_code_icon/1484979849707273201701187dac93b1f862bb8d7604ca480da9c39b2.png', null, 'prod_icon/14849798497223ff4e51.gif', '', '7', ',5', 'images/14849798497224482e40.png,images/14849798497223015cb3.png', '0', '2017-01-21', '什么值得买', '25', '0', '0', '0'), ('356', '网易灰评', '网易旗下首个独立的第三方商品评价体系', 'qr_code_icon/148498000230320171111547289860869188538240.jpg', 'mp_code_icon/14851371177041485137056(1).png', 'prod_icon/1484980002303af25007.jpg', '', '7', '5,6,9,10,12', 'images/1484980002303507a389.jpg,images/1484980002303dc34d2c.jpg,images/14849800023036b26c7d.jpg', '0', '2017-01-21', 'Aaron', '25', '0', '0', '3'), ('357', '拼多多官方', '拼多多是一个让你和朋友一起拼团购物的小程序。拼多多，拼着买，更便宜。', 'qr_code_icon/14849803216342017111851225426425744184800.jpg', null, 'prod_icon/1484980321634a789e98.png', '', '3', ',12', 'images/14849803216345874979.png,images/148498032163404b3573.png,images/148498032163488f8497.png,images/1484980321634bb235d8.png', '0', '2017-01-21', 'kant', '25', '0', '0', '4'), ('358', '大众点评', '大众点评致力于提升消费者生活品质,提供值得信赖的商户,点评,优惠信息,覆盖美食,电影,旅游,酒店,KTV,丽人,结婚,亲子,家装等服务', 'qr_code_icon/14849983187093d85e3dd7d2ccd83c5988262922ecbafb704d1d8-312ca4b10dc95122b25c24feda8c61836c0e297d.jpg', 'mp_code_icon/1484998318709t01c13c410b3d872684.jpg', 'prod_icon/1484998318709836fdf4a167a4aba9848fbddbdeba1be51f809f2-d942144e0a81f045c3a62babc5e5abd21ce8ceaf.jpg', '', '7', '6,9', 'images/148499831870959c45991cae30e18edeaeb9470a6d225349eda1b-dbb036a55004b83ec76aabd47b4f24e05c97f89d.png,images/1484998318709aebaa74dd58f69e7246dad72fe3a05669bfe7004-de78829650a297ec7563976993b787d2fbc13a20.png,images/14849983187093c972df2e252f3331a79cd1d4e3efd5aa94cb557-898f4cff6ae5248665c2d7422e1592fcd9004030.png,images/14849983187094861884162e0ba8880acb502f7dc4e73f8d229ed-47807156680c07aa355933faa3fa03fc56585cfb.png', '0', '2017-01-21', '郭婉瓢盆', '2', '5', '1', '20'), ('359', 'test', 'test', 'qr_code_icon/1485158961508029a1d08-06ac-46e6-b65a-5edb25e4e8fd.jpg', 'mp_code_icon/14851589623821d1c5c39-0155-49cc-96c4-b9fbf79cfade.jpg', 'prod_icon/14851589624815aef7cbf-e675-412e-9354-f6873acf0f7a.jpg', '', '2', ',2', 'images/1485158962727a40727cc-9ea9-474e-bc6b-7fb0021df628.png,images/148515896293538f70cd7-1da5-4442-9c06-87c32c8c00af.png', '0', '2017-01-23', 'TEST', '2', '0', '0', '7'), ('360', '123', '123', 'qr_code_icon/148704577628444247b8f-ff42-4e41-be77-20590c741d0f.png', 'mp_code_icon/1487045776599836226ba-c41b-45f5-bf6a-980c6cba3099.png', 'prod_icon/1487045776614ef155116-c2d9-4001-ae7b-0d8d88a9e669.png', '', '2', ',1', 'images/14870457766336a92fa77-2e72-41ab-938b-8dd6257b71d2.png', '0', '2017-02-14', '123', '2', '0', '0', '0'), ('361', '234', '123', 'qr_code_icon/1487046164525c0d1542f-d88a-45e3-9a18-13f2d074cd31.png', 'mp_code_icon/14870461647000caef450-6deb-4bf8-8984-f5c2f0a8e85c.png', 'prod_icon/148704616473254a07772-0ab8-434b-8224-8355c420f664.png', '', '2', ',1', 'images/148704616475993d4bac7-4629-4908-a7f5-fbfe27e01fc9.png', '0', '2017-02-14', '344', '2', '0', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `app_sufferer`
-- ----------------------------
DROP TABLE IF EXISTS `app_sufferer`;
CREATE TABLE `app_sufferer` (
  `SUFFERER_ID` varchar(32) NOT NULL,
  `SUFFERERNAME` varchar(255) NOT NULL,
  `PID` varchar(20) NOT NULL,
  `PIC` varchar(100) DEFAULT NULL,
  `BIRTHDATE` datetime NOT NULL,
  `SICKHISTORY` varchar(500) DEFAULT NULL,
  `SEX` char(1) NOT NULL,
  `PHONE` varchar(50) DEFAULT NULL,
  `USER_ID` varchar(100) DEFAULT NULL,
  `STATUS` char(1) DEFAULT NULL,
  `RCDDATETIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`SUFFERER_ID`),
  KEY `USER_ID` (`USER_ID`),
  CONSTRAINT `USER_SUFFERER_ID` FOREIGN KEY (`USER_ID`) REFERENCES `xcx_user_manager` (`OPENID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `app_sufferer`
-- ----------------------------
BEGIN;
INSERT INTO `app_sufferer` VALUES ('0e4e422be67e466186f027c66747d988', 'keith', '445224198204153952', 'tmp_66441997o6zAJs9t1BdLLpx9sZI1wDfkKpC458718ac6d4132b904137799903258920.png', '2017-07-30 00:00:00', 'testing', 'M', '13416144628', 'oodUY0cQIhlGgIAC7WSKgRUz60RQ', 'A', '2017-07-30 21:04:34'), ('1cd0e60c103d41e88e86e354d79eb9f7', 'sam', '445224198204153952', 'tmp_66441997o6zAJs9t1BdLLpx9sZI1wDfkKpC42d9c463793b2714d8dd8de058e64fb44.png', '2017-07-24 00:00:00', 'sick history', 'M', '13416144628', 'oodUY0cQIhlGgIAC7WSKgRUz60RQ', 'A', '2017-07-24 22:19:04'), ('247106f5f5274ead9642e830b379df2d', 'samwu', '445224198204153972', 'tmp_66441997o6zAJs9t1BdLLpx9sZI1wDfkKpC489d3600dc5b37095ca35023fe1df781b.png', '2017-07-29 00:00:00', 'no', 'M', '13416144625', 'oodUY0cQIhlGgIAC7WSKgRUz60RQ', 'A', '2017-07-29 21:46:14');
COMMIT;

-- ----------------------------
--  Table structure for `app_user_info`
-- ----------------------------
DROP TABLE IF EXISTS `app_user_info`;
CREATE TABLE `app_user_info` (
  `USER_ID` int(100) NOT NULL AUTO_INCREMENT,
  `USERNAME` varchar(255) DEFAULT NULL,
  `PASSWORD` varchar(255) DEFAULT NULL,
  `NAME` varchar(255) DEFAULT NULL,
  `RIGHTS` varchar(255) DEFAULT NULL,
  `ROLE_ID` varchar(100) DEFAULT NULL,
  `LAST_LOGIN` varchar(255) DEFAULT NULL,
  `IP` varchar(100) DEFAULT NULL,
  `STATUS` varchar(32) DEFAULT NULL,
  `BZ` varchar(255) DEFAULT NULL,
  `PHONE` varchar(100) DEFAULT NULL,
  `SFID` varchar(100) DEFAULT NULL,
  `START_TIME` varchar(100) DEFAULT NULL,
  `END_TIME` varchar(100) DEFAULT NULL,
  `YEARS` int(10) DEFAULT NULL,
  `NUMBER` varchar(100) DEFAULT NULL,
  `EMAIL` varchar(32) DEFAULT NULL,
  `ICON` varchar(100) DEFAULT 'user_defaulticon.png',
  PRIMARY KEY (`USER_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `app_user_info`
-- ----------------------------
BEGIN;
INSERT INTO `app_user_info` VALUES ('3', 'imood', '49ac5974b8780fefb21d1d0dfbc55ac039fb565f', 'imood', null, null, '2017-01-10 09:19:35.841', null, null, null, null, null, null, null, null, null, '3098236111@qq.com', 'user_defaulticon.png'), ('4', 'hunter', '2f25f47249aacf58373c44cbbaac4373dfa93123', 'hunter', null, null, '2017-01-10 09:20:00.372', null, null, null, null, null, null, null, null, null, 'hunter@fineland.com.cn', '1484898982734timg.jpg'), ('7', 'liyang1322679317', 'e4da4ca68ea8aeaa9216b97d9a684588947822dd', 'liyang1322679317', null, null, '2017-01-10 09:39:26.091', null, null, null, null, null, null, null, null, null, '1322679317@qq.com', 'user_defaulticon.png'), ('8', 'huangzy', '24a5a01116169e8356ccad433619cd5dec8cc278', 'huangzy', null, null, '2017-01-10 09:41:44.657', null, null, null, null, null, null, null, null, null, 'zhiyuan7206@163.com', 'user_defaulticon.png'), ('9', 'zgb', '63aa65b16fc79cdacc658a9e52d52aedfd84e5ae', 'zgb', null, null, '2017-01-10 09:42:18.142', null, null, null, null, null, null, null, null, null, 'zgb@fineland.com.cn', 'user_defaulticon.png'), ('10', 'liang012158', '440d5d57bf8ed69ba7a6d11b0d3cf3a89a830ff6', 'liang012158', null, null, '2017-01-10 09:42:37.924', null, null, null, null, null, null, null, null, null, 'liang012158@126.com', 'user_defaulticon.png'), ('11', 'aa', '74a0b1b82843cd8cd34624c281f66e7742c9b15d', 'aa', null, null, '2017-01-10 09:55:52.35', null, null, null, null, null, null, null, null, null, '1342824467@qq.com', 'user_defaulticon.png'), ('12', '321321', '55089ebf49f7aaade1499d4a41e488802c485d24', '321321', null, null, '2017-01-10 10:00:48.67', null, null, null, null, null, null, null, null, null, '32132', 'user_defaulticon.png'), ('13', 'Pisces', '059562c9de8b441112eb454468eaea0aff84e3c1', 'Pisces', null, null, '2017-01-10 11:06:54.735', null, null, null, null, null, null, null, null, null, '294265271@qq.com', 'user_defaulticon.png'), ('14', 'Pisces', '059562c9de8b441112eb454468eaea0aff84e3c1', 'Pisces', null, null, '2017-01-10 14:55:31.898', null, null, null, null, null, null, null, null, null, '2942652711@qq.com', 'user_defaulticon.png'), ('15', 'xiexie', 'c7e38c7358ffcd0714ae832918eb185bfe6f9886', 'xiexie', null, null, '2017-01-10 14:58:48.153', null, null, null, null, null, null, null, null, null, '1342824467@qq.com', 'user_defaulticon.png'), ('16', 'xie', '3d3aef080f46bd1a3b04e12765b918e3bd51574f', 'xie', null, null, '2017-01-10 15:27:33.513', null, null, null, null, null, null, null, null, null, '13428244677@qq.com', 'user_defaulticon.png'), ('17', 'Pisces', '059562c9de8b441112eb454468eaea0aff84e3c1', 'Pisces', null, null, '2017-01-10 15:59:15.053', null, null, null, null, null, null, null, null, null, '294265271@qq.com', 'user_defaulticon.png'), ('18', 'wch', '13b6b72a2c709d2f763ccf7404d449575eecb5ef', 'wch', null, null, '2017-01-10 17:04:02.412', null, null, null, null, null, null, null, null, null, 'w17ch@126.com', '1484898835968gehu.jpg'), ('19', 'pisces', 'f8777036ee144aa474da17e69ee2963ff24dc940', 'pisces', null, null, '2017-01-10 17:26:08.102', null, null, null, null, null, null, null, null, null, '294265271@qq.com', 'user_defaulticon.png'), ('20', '111111', '7ec8aa461c2c28be905e1dfb0be256a971aa6108', '111111', null, null, '2017-01-11 11:27:17.296', null, null, null, null, null, null, null, null, null, '111111', 'user_defaulticon.png'), ('21', 'chis', '26a1bfc60d69f52dd12d2debd04dcb325e646a80', 'chis', null, null, '2017-01-13 09:01:18.946', null, null, null, null, null, null, null, null, null, 'xuxy@fineland.cn', '1484962405647b77fb6fe650c1799368f17e328850746_t.jpg'), ('22', 'Yao', '9534ae2d43af92f391154956b56b12f3ce81564b', 'Yao', null, null, '2017-01-17 11:55:02.314', null, null, null, null, null, null, null, null, null, '894889364@qq.com', 'user_defaulticon.png'), ('23', 'tony', 'bd80307a73a938a2fc0538c10aacdd0bed6e12c6', 'tony', null, null, '2017-01-19 11:44:32.936', null, null, null, null, null, null, null, null, null, '63855901@qq.com', 'user_defaulticon.png'), ('24', 'Nero_Li', '3bba63068baa1812e9dc7254adae35298ebed4c6', 'Nero_Li', null, null, '2017-01-20 15:31:15.723', null, null, null, null, null, null, null, null, null, '375892799@qq.com', '1484897494739334907-106.jpg'), ('25', '郭家大少', '2540e8ba798f5580580214ca02f1bbeb538f7678', '郭家大少', null, null, '2017-01-20 15:36:43.48', null, null, null, null, null, null, null, null, null, '635189028@qq.com', 'user_defaulticon.png'), ('26', 'tanwing', 'af79c2a749f37c123a2608a35b40011c1be00155', 'tanwing', null, null, '2017-01-20 16:09:13.933', null, null, null, null, null, null, null, null, null, 'tanwing@yeah.net', 'user_defaulticon.png'), ('27', '15334170999', '830d42900e477dc6aec827e841b4ae102b6b8d85', '15334170999', null, null, '2017-01-21 09:50:48.497', null, null, null, null, null, null, null, null, null, '1322679317@163.com', 'user_defaulticon.png'), ('28', 'cjdlss1', '2c2464623bf03d06a36be9f4a1657ad9fc971f86', 'cjdlss1', null, null, '2017-01-21 09:54:46.827', null, null, null, null, null, null, null, null, null, '823890385@qq.com', 'user_defaulticon.png'), ('29', 'cjdlss', '5902608dbbede9d5d18fdaa9cac6332eb0f7db67', 'cjdlss', null, null, '2017-01-21 09:56:20.78', null, null, null, null, null, null, null, null, null, '929907882@qq.com', 'user_defaulticon.png'), ('30', '18819171904', '71ef334e1dfe0d75c2add685cfb6a73f8e17e5f4', '18819171904', null, null, '2017-01-21 11:29:09.254', null, null, null, null, null, null, null, null, null, 'liyingnan00@foxmail.com', 'user_defaulticon.png'), ('31', '小漠君', '9eec508318a1a0681ff538e618194f7ac513a71a', '小漠君', null, null, '2017-01-21 11:38:07.593', null, null, null, null, null, null, null, null, null, '312571930@qq.com', 'user_defaulticon.png'), ('32', '18899737769', '4b6da48cec7776376c52ace2c5d2f4faec8768b8', '18899737769', null, null, '2017-01-21 14:45:00.13', null, null, null, null, null, null, null, null, null, '1014888954@qq.com', 'user_defaulticon.png');
COMMIT;

-- ----------------------------
--  Table structure for `db_fhdb`
-- ----------------------------
DROP TABLE IF EXISTS `db_fhdb`;
CREATE TABLE `db_fhdb` (
  `FHDB_ID` varchar(100) NOT NULL,
  `USERNAME` varchar(50) DEFAULT NULL COMMENT '操作用户',
  `BACKUP_TIME` varchar(32) DEFAULT NULL COMMENT '备份时间',
  `TABLENAME` varchar(50) DEFAULT NULL COMMENT '表名',
  `SQLPATH` varchar(300) DEFAULT NULL COMMENT '存储位置',
  `TYPE` int(1) NOT NULL COMMENT '类型',
  `DBSIZE` varchar(10) DEFAULT NULL COMMENT '文件大小',
  `BZ` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`FHDB_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `db_timingbackup`
-- ----------------------------
DROP TABLE IF EXISTS `db_timingbackup`;
CREATE TABLE `db_timingbackup` (
  `TIMINGBACKUP_ID` varchar(100) NOT NULL,
  `JOBNAME` varchar(50) DEFAULT NULL COMMENT '任务名称',
  `CREATE_TIME` varchar(32) DEFAULT NULL COMMENT '创建时间',
  `TABLENAME` varchar(50) DEFAULT NULL COMMENT '表名',
  `STATUS` int(1) NOT NULL COMMENT '类型',
  `FHTIME` varchar(30) DEFAULT NULL COMMENT '时间规则',
  `TIMEEXPLAIN` varchar(100) DEFAULT NULL COMMENT '规则说明',
  `BZ` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`TIMINGBACKUP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `db_timingbackup`
-- ----------------------------
BEGIN;
INSERT INTO `db_timingbackup` VALUES ('311e06c34a5e4518a86d5d30799f9b55', 'sys_app_user_515762', '2016-04-11 17:04:55', 'sys_app_user', '2', '1/2 * * ? * *', '每个月的 每周 每天 每小时执行一次', '备份任务');
COMMIT;

-- ----------------------------
--  Table structure for `oa_department`
-- ----------------------------
DROP TABLE IF EXISTS `oa_department`;
CREATE TABLE `oa_department` (
  `DEPARTMENT_ID` varchar(100) NOT NULL,
  `NAME` varchar(30) DEFAULT NULL COMMENT '名称',
  `NAME_EN` varchar(50) DEFAULT NULL COMMENT '英文',
  `BIANMA` varchar(50) DEFAULT NULL COMMENT '编码',
  `PARENT_ID` varchar(100) DEFAULT NULL COMMENT '上级ID',
  `BZ` varchar(255) DEFAULT NULL COMMENT '备注',
  `HEADMAN` varchar(30) DEFAULT NULL COMMENT '负责人',
  `TEL` varchar(50) DEFAULT NULL COMMENT '电话',
  `FUNCTIONS` varchar(255) DEFAULT NULL COMMENT '部门职能',
  `ADDRESS` varchar(255) DEFAULT NULL COMMENT '地址',
  PRIMARY KEY (`DEPARTMENT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `oa_department`
-- ----------------------------
BEGIN;
INSERT INTO `oa_department` VALUES ('0956d8c279274fca92f4091f2a69a9ad', '销售会计', 'xiaokuai', '05896', 'd41af567914a409893d011aa53eda797', '', '', '', '', ''), ('3e7227e11dc14b4d9e863dd1a1fcedf6', '成本会计', 'chengb', '03656', 'd41af567914a409893d011aa53eda797', '', '', '', '', ''), ('5cccdb7c432449d8b853c52880058140', 'B公司', 'b', '002', '0', '冶铁', '李四', '112', '冶铁', '河北'), ('83a25761c618457cae2fa1211bd8696d', '销售B组', 'xiaob', '002365', 'cbbc84eddde947ba8af7d509e430eb70', '', '李四', '', '', ''), ('8f8b045470f342fdbc4c312ab881d62b', '销售A组', 'xiaoA', '0326', 'cbbc84eddde947ba8af7d509e430eb70', '', '张三', '0201212', '', ''), ('a0982dea52554225ab682cd4b421de47', '1队', 'yidui', '02563', '8f8b045470f342fdbc4c312ab881d62b', '', '小王', '12356989', '', ''), ('a6c6695217ba4a4dbfe9f7e9d2c06730', 'A公司', 'a', '001', '0', '挖煤', '张三', '110', '洼煤矿', '山西'), ('cbbc84eddde947ba8af7d509e430eb70', '销售部', 'xiaoshoubu', '00201', '5cccdb7c432449d8b853c52880058140', '推销商品', '小明', '11236', '推销商品', '909办公室'), ('d41af567914a409893d011aa53eda797', '财务部', 'caiwubu', '00101', 'a6c6695217ba4a4dbfe9f7e9d2c06730', '负责发工资', '王武', '11236', '管理财务', '308办公室');
COMMIT;

-- ----------------------------
--  Table structure for `sys_addition_booking_publish`
-- ----------------------------
DROP TABLE IF EXISTS `sys_addition_booking_publish`;
CREATE TABLE `sys_addition_booking_publish` (
  `TID` varchar(32) NOT NULL,
  `DOCTOR_ID` varchar(32) DEFAULT NULL,
  `ADDITIONCOUNT` int(11) DEFAULT NULL,
  `PRICE` decimal(9,1) DEFAULT NULL,
  `VIPPRICE` decimal(9,1) DEFAULT NULL,
  `EXPIREDATE` datetime DEFAULT NULL,
  `RCDDATE` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `RCDSTS` char(1) DEFAULT NULL,
  PRIMARY KEY (`TID`),
  KEY `DOCTOR_ID` (`DOCTOR_ID`),
  CONSTRAINT `doctor_add_fk` FOREIGN KEY (`DOCTOR_ID`) REFERENCES `sys_doctor` (`DOCTOR_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sys_addition_booking_publish`
-- ----------------------------
BEGIN;
INSERT INTO `sys_addition_booking_publish` VALUES ('1dd6e9c434124668bee51428934faaf0', 'dc11089eb4ab48b3bef759899cea452e', '7', '34.0', '30.0', '2017-09-30 00:00:00', '2017-08-16 22:29:07', 'A'), ('9e460a6e7b3d4fec8170cf4d157fc455', 'dc11089eb4ab48b3bef759899cea452e', '6', '17.0', '10.0', '2017-09-30 00:00:00', '2017-08-16 22:03:12', 'A');
COMMIT;

-- ----------------------------
--  Table structure for `sys_bc_publish`
-- ----------------------------
DROP TABLE IF EXISTS `sys_bc_publish`;
CREATE TABLE `sys_bc_publish` (
  `TID` varchar(32) NOT NULL,
  `DOCTOR_ID` varchar(32) DEFAULT NULL,
  `PRICE` decimal(9,1) DEFAULT NULL,
  `VIPPRICE` decimal(9,1) DEFAULT NULL,
  `GROUPPRICE` decimal(9,1) DEFAULT NULL,
  `GROUPVIPPRICE` decimal(9,1) DEFAULT NULL,
  `EXPIREDATE` datetime DEFAULT NULL,
  `RCDDATE` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `RCDSTS` char(1) DEFAULT 'A',
  PRIMARY KEY (`TID`),
  KEY `DOCTOR_ID` (`DOCTOR_ID`),
  CONSTRAINT `b_doctor_fk` FOREIGN KEY (`DOCTOR_ID`) REFERENCES `sys_doctor` (`DOCTOR_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sys_bc_publish`
-- ----------------------------
BEGIN;
INSERT INTO `sys_bc_publish` VALUES ('72e9ffb7b02749278c6271c2b6d2be00', 'dc11089eb4ab48b3bef759899cea452e', '120.0', '100.0', '90.0', '80.0', '2017-09-30 00:00:00', '2017-08-29 21:01:27', 'A'), ('afb153ac958b4ee28c7447192a18faba', 'dc11089eb4ab48b3bef759899cea452e', '201.0', '171.0', '58.0', '51.0', '2017-09-30 00:00:00', '2017-08-27 23:14:06', 'A'), ('ba59fb877a6a4887870723f4f663c02a', 'dc11089eb4ab48b3bef759899cea452e', '120.0', '100.0', '90.0', '80.0', '2017-08-31 00:00:00', '2017-08-28 20:25:51', 'A');
COMMIT;

-- ----------------------------
--  Table structure for `sys_category`
-- ----------------------------
DROP TABLE IF EXISTS `sys_category`;
CREATE TABLE `sys_category` (
  `CATEGORY_ID` varchar(32) NOT NULL,
  `CATEGORYNAME` varchar(100) NOT NULL,
  `HOSPITAL_ID` varchar(32) NOT NULL,
  `DESCRIPTION` varchar(255) DEFAULT NULL,
  `RCDTIMESTEMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `RCDSTS` char(1) DEFAULT NULL,
  PRIMARY KEY (`CATEGORY_ID`),
  KEY `HOSPITAL_ID` (`HOSPITAL_ID`),
  CONSTRAINT `hospital_category_fk` FOREIGN KEY (`HOSPITAL_ID`) REFERENCES `sys_hospital` (`HOSPITAL_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sys_category`
-- ----------------------------
BEGIN;
INSERT INTO `sys_category` VALUES ('14bea5d43632498bba1adee7e3f714d4', '普通内科', '4f62db1b57b144f0a2220ba1623ae74d', '普通内科', null, 'A'), ('4c60a31f85684e3aaaa1a0f9a8259e0a', '儿科', '4d543a64e7b944a695d7558da953b21d', '儿科，各种儿科', null, 'A'), ('512e2e389cc247949e6bb73c18685e6f', '普通内科', '4d543a64e7b944a695d7558da953b21d', '普通内科，急诊等', null, 'A');
COMMIT;

-- ----------------------------
--  Table structure for `sys_createcode`
-- ----------------------------
DROP TABLE IF EXISTS `sys_createcode`;
CREATE TABLE `sys_createcode` (
  `CREATECODE_ID` varchar(100) NOT NULL,
  `PACKAGENAME` varchar(50) DEFAULT NULL COMMENT '包名',
  `OBJECTNAME` varchar(50) DEFAULT NULL COMMENT '类名',
  `TABLENAME` varchar(50) DEFAULT NULL COMMENT '表名',
  `FIELDLIST` varchar(5000) DEFAULT NULL COMMENT '属性集',
  `CREATETIME` varchar(100) DEFAULT NULL COMMENT '创建时间',
  `TITLE` varchar(255) DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`CREATECODE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sys_createcode`
-- ----------------------------
BEGIN;
INSERT INTO `sys_createcode` VALUES ('002ea762e3e242a7a10ea5ca633701d8', 'system', 'Buttonrights', 'sys_,fh,BUTTONRIGHTS', 'NAME,fh,String,fh,名称,fh,是,fh,无,fh,255Q313596790', '2016-01-16 23:20:36', '按钮权限'), ('487454df44cc4169901571a31adf9a12', 'new', 'News', 'TB_,fh,NEWS', 'TITLE,fh,String,fh,标题,fh,是,fh,无,fh,255Q313596790', '2017-01-09 14:29:13', '新闻管理'), ('49d985e081ed44e6b34ba1b8c5466e39', 'fhdb', 'TimingBackUp', 'DB_,fh,TIMINGBACKUP', 'JOBNAME,fh,String,fh,任务名称,fh,否,fh,无,fh,50Q313596790CREATE_TIME,fh,Date,fh,创建时间,fh,否,fh,无,fh,32Q313596790TABLENAME,fh,String,fh,表名,fh,是,fh,无,fh,50Q313596790TYPE,fh,Integer,fh,类型,fh,否,fh,无,fh,1Q313596790FHTIME,fh,String,fh,时间规则,fh,是,fh,无,fh,30Q313596790TIMEEXPLAIN,fh,String,fh,规则说明,fh,是,fh,无,fh,100Q313596790BZ,fh,String,fh,备注,fh,是,fh,无,fh,255Q313596790', '2016-04-09 11:53:38', '定时备份'), ('65d5b3e5e7a2464ead8f29178276112d', 'miniapp', 'AppColumnController', ',fh,APPCOLUMNCONTROLLER', 'APPCOLUMN_NAME,fh,String,fh,栏目名称,fh,是,fh,无,fh,50Q313596790APPCOLUMN_ICON,fh,String,fh,图片,fh,是,fh,无,fh,100Q313596790', '2017-01-09 15:19:02', '小程序产品模块'), ('bf35ab8b2d064bf7928a04bba5e5a6dd', 'system', 'Fhsms', 'SYS_,fh,FHSMS', 'CONTENT,fh,String,fh,内容,fh,是,fh,无,fh,1000Q313596790TYPE,fh,String,fh,类型,fh,否,fh,无,fh,5Q313596790TO_USERNAME,fh,String,fh,收信人,fh,是,fh,无,fh,255Q313596790FROM_USERNAME,fh,String,fh,发信人,fh,是,fh,无,fh,255Q313596790SEND_TIME,fh,String,fh,发信时间,fh,是,fh,无,fh,100Q313596790STATUS,fh,String,fh,状态,fh,否,fh,无,fh,5Q313596790SANME_ID,fh,String,fh,共同ID,fh,是,fh,无,fh,100Q313596790', '2016-03-27 21:39:45', '站内信'), ('c7586f931fd44c61beccd3248774c68c', 'system', 'Department', 'SYS_,fh,DEPARTMENT', 'NAME,fh,String,fh,名称,fh,是,fh,无,fh,30Q313596790NAME_EN,fh,String,fh,英文,fh,是,fh,无,fh,50Q313596790BIANMA,fh,String,fh,编码,fh,是,fh,无,fh,50Q313596790PARENT_ID,fh,String,fh,上级ID,fh,否,fh,无,fh,100Q313596790BZ,fh,String,fh,备注,fh,是,fh,无,fh,255Q313596790HEADMAN,fh,String,fh,负责人,fh,是,fh,无,fh,30Q313596790TEL,fh,String,fh,电话,fh,是,fh,无,fh,50Q313596790FUNCTIONS,fh,String,fh,部门职能,fh,是,fh,无,fh,255Q313596790ADDRESS,fh,String,fh,地址,fh,是,fh,无,fh,255Q313596790', '2015-12-20 01:49:25', '组织机构'), ('c937e21208914e5b8fb1202c685bbf2f', 'fhdb', 'Fhdb', 'DB_,fh,FHDB', 'USERNAME,fh,String,fh,操作用户,fh,否,fh,无,fh,50Q313596790BACKUP_TIME,fh,Date,fh,备份时间,fh,否,fh,无,fh,32Q313596790TABLENAME,fh,String,fh,表名,fh,是,fh,无,fh,50Q313596790SQLPATH,fh,String,fh,存储位置,fh,否,fh,无,fh,300Q313596790TYPE,fh,Integer,fh,类型,fh,是,fh,无,fh,1Q313596790DBSIZE,fh,String,fh,文件大小,fh,否,fh,无,fh,10Q313596790BZ,fh,String,fh,备注,fh,否,fh,无,fh,255Q313596790', '2016-03-30 13:46:54', '数据库管理'), ('d514dbd2474d4b6c8b6ab9904cc9cc7c', 'new', 'News', 'TB_,fh,NEWS', 'TITLE,fh,String,fh,标题,fh,是,fh,无,fh,255Q313596790', '2016-01-25 16:38:14', '新闻管理'), ('dbd7b8330d774dcabd184eca8668a295', 'system', 'Fhsms', 'SYS_,fh,FHSMS', 'CONTENT,fh,String,fh,内容,fh,是,fh,无,fh,1000Q313596790TYPE,fh,String,fh,类型,fh,否,fh,无,fh,5Q313596790TO_USERNAME,fh,String,fh,收信人,fh,是,fh,无,fh,255Q313596790FROM_USERNAME,fh,String,fh,发信人,fh,是,fh,无,fh,255Q313596790SEND_TIME,fh,String,fh,发信时间,fh,是,fh,无,fh,100Q313596790STATUS,fh,String,fh,状态,fh,否,fh,无,fh,5Q313596790SANME_ID,fh,String,fh,共同ID,fh,是,fh,无,fh,100Q313596790', '2016-01-23 01:44:15', '站内信'), ('fe239f8742194481a5b56f90cad71520', 'system', 'Fhbutton', 'SYS_,fh,FHBUTTON', 'NAME,fh,String,fh,名称,fh,是,fh,无,fh,30Q313596790QX_NAME,fh,String,fh,权限标识,fh,是,fh,无,fh,50Q313596790BZ,fh,String,fh,备注,fh,是,fh,无,fh,255Q313596790', '2016-01-15 18:38:40', '按钮管理');
COMMIT;

-- ----------------------------
--  Table structure for `sys_dictionaries`
-- ----------------------------
DROP TABLE IF EXISTS `sys_dictionaries`;
CREATE TABLE `sys_dictionaries` (
  `DICTIONARIES_ID` varchar(32) NOT NULL,
  `NAME` varchar(30) DEFAULT NULL COMMENT '名称',
  `NAME_EN` varchar(50) DEFAULT NULL COMMENT '英文',
  `BIANMA` varchar(50) DEFAULT NULL COMMENT '编码',
  `ORDER_BY` int(11) NOT NULL COMMENT '排序',
  `PARENT_ID` varchar(100) DEFAULT NULL COMMENT '上级ID',
  `BZ` varchar(255) DEFAULT NULL COMMENT '备注',
  `TBSNAME` varchar(100) DEFAULT NULL COMMENT '排查表',
  PRIMARY KEY (`DICTIONARIES_ID`),
  UNIQUE KEY `unique_id` (`BIANMA`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sys_dictionaries`
-- ----------------------------
BEGIN;
INSERT INTO `sys_dictionaries` VALUES ('0040b19a2bc44497a463ed49ec2ef3b7', '主任医师', 'ZR', '00201', '1', 'a03976cc823848b798d97595828a9808', '主任医师', ''), ('0fa1047bb7674f00b18801f0ba3c4dea', '三甲', 'SJ', '00101', '1', '98615e7f05c94992997c2d0ca02b80b5', '国内高级别', ''), ('1cf2d22e472e408d8a7508e04037ad24', '福田区', 'FT', '003030202', '2', '85a6a16c18b649e5a9045919e40040bc', '', ''), ('23133220b9114592894be9801a6a20e3', '荔湾区', 'LW', '003030106', '4', 'a5cab9b9a00147b9a9d8f9464bf70762', '', ''), ('3b456fb29a8b462480d6d3205bdb9102', '中山市', 'ZS', '0030303', '2', '4c499a53323240e694694f7e7a25c5bf', '', ''), ('3c416e6b6b364e62aecb73828beac49a', '黄埔区', 'HP', '003030104', '6', 'a5cab9b9a00147b9a9d8f9464bf70762', '', ''), ('4a296986db6f49a78d19db84b180e8b7', '社区', 'SQ', '00103', '3', '98615e7f05c94992997c2d0ca02b80b5', '社区医院', ''), ('4c499a53323240e694694f7e7a25c5bf', '广东省', 'GD', '00303', '3', 'be4a8c5182c744d28282a5345783a77f', '', ''), ('52d6a1a4727b4761af20151c69d6352d', '南山区', 'NS', '003030201', '1', '85a6a16c18b649e5a9045919e40040bc', '', ''), ('5a43e4766e7a449e80c791287952a1ec', '番禺区', 'PY', '003030107', '7', 'a5cab9b9a00147b9a9d8f9464bf70762', '', ''), ('67562b890d1c42678dc8dfb4cab17faf', '南沙区', 'NS', '003030111', '11', 'a5cab9b9a00147b9a9d8f9464bf70762', '', ''), ('6cee34131ecd48b788cb6a88750a44b4', '增城区', 'ZC', '003030110', '10', 'a5cab9b9a00147b9a9d8f9464bf70762', '', ''), ('85a6a16c18b649e5a9045919e40040bc', '深圳市', 'SZ', '0030302', '2', '4c499a53323240e694694f7e7a25c5bf', '', ''), ('981ec89c11d64e5f8a5bf91293662569', '白云区', 'BY', '003030105', '5', 'a5cab9b9a00147b9a9d8f9464bf70762', '', ''), ('98615e7f05c94992997c2d0ca02b80b5', '医院级别', 'Level', '001', '2', '0', '医院级别', ''), ('9af18c5627b24494a425b2e5d00bd44f', '医师', 'YS', '00203', '3', 'a03976cc823848b798d97595828a9808', '医师', ''), ('a03976cc823848b798d97595828a9808', '医生职称', 'YSZC', '002', '3', '0', '医生职称', ''), ('a2aa32d5488a43bfab6c7db44a979801', '副主任医师', 'FZR', '00202', '2', 'a03976cc823848b798d97595828a9808', '副主任医师', ''), ('a5cab9b9a00147b9a9d8f9464bf70762', '广州市', 'GZ', '0030301', '1', '4c499a53323240e694694f7e7a25c5bf', '', ''), ('a8f541ba1fcb49e4973d748376e7b566', '越秀区', 'YS', '003030103', '3', 'a5cab9b9a00147b9a9d8f9464bf70762', '', ''), ('b415bba0fa80432eb7d9c7c2cf05359a', '从化区', 'CH', '003030109', '9', 'a5cab9b9a00147b9a9d8f9464bf70762', '', ''), ('bbd36c2e3e244e2c94f9a8630a010d8d', '天河区', 'TH', '003030101', '1', 'a5cab9b9a00147b9a9d8f9464bf70762', '', ''), ('be4a8c5182c744d28282a5345783a77f', '地区', 'diqu', '003', '1', '0', '地区', ''), ('c8dafdee9bde4a379481541d6a8ad114', '龙岗区', 'LG', '003030203', '3', '85a6a16c18b649e5a9045919e40040bc', '', ''), ('d376942774054dd9912934347d78ce64', '海珠区', 'HZ', '003030102', '2', 'a5cab9b9a00147b9a9d8f9464bf70762', '', ''), ('e820ba7eb1c44686a9ac02692073adb4', '区级', 'QJ', '00102', '2', '98615e7f05c94992997c2d0ca02b80b5', '区级医院', ''), ('fd4dc975717546b98669b6711b35f85b', '花都区', 'HD', '003030108', '8', 'a5cab9b9a00147b9a9d8f9464bf70762', '', '');
COMMIT;

-- ----------------------------
--  Table structure for `sys_doctor`
-- ----------------------------
DROP TABLE IF EXISTS `sys_doctor`;
CREATE TABLE `sys_doctor` (
  `DOCTOR_ID` varchar(32) NOT NULL,
  `NAME` varchar(30) DEFAULT NULL,
  `PID` varchar(18) NOT NULL,
  `HOSPITAL_ID` varchar(32) DEFAULT NULL,
  `CATEGORY_ID` varchar(32) DEFAULT NULL,
  `LEVEL_ID` varchar(32) DEFAULT NULL COMMENT '职称ID',
  `DESCRIPTION` varchar(255) DEFAULT NULL,
  `PHONE` varchar(30) DEFAULT NULL,
  `EMAIL` varchar(50) DEFAULT NULL,
  `USER_ID` varchar(100) DEFAULT NULL,
  `RCDSTS` char(1) DEFAULT NULL,
  `RCDTIMESTEMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `OPENID` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`DOCTOR_ID`),
  KEY `CATEGORY_ID` (`CATEGORY_ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `OPENID` (`OPENID`),
  KEY `HOSPITAL_ID` (`HOSPITAL_ID`),
  KEY `LEVEL_ID` (`LEVEL_ID`),
  CONSTRAINT `appuser_doctor_fk` FOREIGN KEY (`OPENID`) REFERENCES `xcx_user_manager` (`OPENID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `category_docker_fk1` FOREIGN KEY (`CATEGORY_ID`) REFERENCES `sys_category` (`CATEGORY_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `docker_hospital_fk` FOREIGN KEY (`HOSPITAL_ID`) REFERENCES `sys_hospital` (`HOSPITAL_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `level_fk` FOREIGN KEY (`LEVEL_ID`) REFERENCES `sys_dictionaries` (`DICTIONARIES_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `user_docker_fk` FOREIGN KEY (`USER_ID`) REFERENCES `sys_user` (`USER_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sys_doctor`
-- ----------------------------
BEGIN;
INSERT INTO `sys_doctor` VALUES ('dc11089eb4ab48b3bef759899cea452e', 'sam', '445224198204153952', '4f62db1b57b144f0a2220ba1623ae74d', '14bea5d43632498bba1adee7e3f714d4', '9af18c5627b24494a425b2e5d00bd44f', '内科高手', '13416144628', 'mshwu@163.com', '4c97b4d20fcf4fa28969e5326257a212', 'A', '2017-08-12 10:26:41', 'oodUY0cQIhlGgIAC7WSKgRUz60RQ');
COMMIT;

-- ----------------------------
--  Table structure for `sys_fhbutton`
-- ----------------------------
DROP TABLE IF EXISTS `sys_fhbutton`;
CREATE TABLE `sys_fhbutton` (
  `FHBUTTON_ID` varchar(100) NOT NULL,
  `NAME` varchar(30) DEFAULT NULL COMMENT '名称',
  `QX_NAME` varchar(50) DEFAULT NULL COMMENT '权限标识',
  `BZ` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`FHBUTTON_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sys_fhbutton`
-- ----------------------------
BEGIN;
INSERT INTO `sys_fhbutton` VALUES ('3542adfbda73410c976e185ffe50ad06', '导出EXCEL', 'toExcel', '导出EXCEL'), ('46992ea280ba4b72b29dedb0d4bc0106', '发邮件', 'email', '发送电子邮件'), ('4efa162fce8340f0bd2dcd3b11d327ec', '导入EXCEL', 'FromExcel', '导入EXCEL到系统用户'), ('cc51b694d5344d28a9aa13c84b7166cd', '发短信', 'sms', '发送短信'), ('da7fd386de0b49ce809984f5919022b8', '站内信', 'FHSMS', '发送站内信');
COMMIT;

-- ----------------------------
--  Table structure for `sys_fhsms`
-- ----------------------------
DROP TABLE IF EXISTS `sys_fhsms`;
CREATE TABLE `sys_fhsms` (
  `FHSMS_ID` varchar(100) NOT NULL,
  `CONTENT` varchar(1000) DEFAULT NULL COMMENT '内容',
  `TYPE` varchar(5) DEFAULT NULL COMMENT '类型',
  `TO_USERNAME` varchar(255) DEFAULT NULL COMMENT '收信人',
  `FROM_USERNAME` varchar(255) DEFAULT NULL COMMENT '发信人',
  `SEND_TIME` varchar(100) DEFAULT NULL COMMENT '发信时间',
  `STATUS` varchar(5) DEFAULT NULL COMMENT '状态',
  `SANME_ID` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`FHSMS_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sys_fhsms`
-- ----------------------------
BEGIN;
INSERT INTO `sys_fhsms` VALUES ('05879f5868824f35932ee9f2062adc03', '你好', '2', 'admin', 'san', '2016-01-25 14:05:31', '1', 'b311e893228f42d5a05dbe16917fd16f'), ('2635dd035c6f4bb5a091abdd784bd899', '你好', '2', 'san', 'admin', '2016-01-25 14:05:02', '2', '1b7637306683460f89174c2b025862b5'), ('28c01b72c7a542e0bb2188d83621c4bd', 'test', '1', 'admin', 'sunshine', '2017-08-23 21:10:30', '2', '814c01dc4c80483ebcddb671a52f279a'), ('52378ccd4e2d4fe08994d1652af87c68', '你好', '1', 'admin', 'san', '2016-01-25 16:26:44', '1', '920b20dafdfb4c09b560884eb277c51d'), ('77ed13f9c49a4c4bb460c41b8580dd36', 'gggg', '2', 'admin', 'san', '2016-01-24 21:22:43', '2', 'dd9ee339576e48c5b046b94fa1901d00'), ('98a6869f942042a1a037d9d9f01cb50f', '你好', '1', 'admin', 'san', '2016-01-25 14:05:02', '2', '1b7637306683460f89174c2b025862b5'), ('9e00295529014b6e8a27019cbccb3da1', '柔柔弱弱', '1', 'admin', 'san', '2016-01-24 21:22:57', '1', 'a29603d613ea4e54b5678033c1bf70a6'), ('aca0378db2144156a98a109fefab858a', 'test', '2', 'sunshine', 'admin', '2017-08-23 21:10:30', '2', '814c01dc4c80483ebcddb671a52f279a'), ('d3aedeb430f640359bff86cd657a8f59', '你好', '1', 'admin', 'san', '2016-01-24 21:22:12', '1', 'f022fbdce3d845aba927edb698beb90b'), ('e5376b1bd54b489cb7f2203632bd74ec', '管理员好', '2', 'admin', 'san', '2016-01-25 14:06:13', '2', 'b347b2034faf43c79b54be4627f3bd2b'), ('e613ac0fcc454f32895a70b747bf4fb5', '你也好', '2', 'admin', 'san', '2016-01-25 16:27:54', '2', 'ce8dc3b15afb40f28090f8b8e13f078d'), ('f25e00cfafe741a3a05e3839b66dc7aa', '你好', '2', 'san', 'admin', '2016-01-25 16:26:44', '1', '920b20dafdfb4c09b560884eb277c51d');
COMMIT;

-- ----------------------------
--  Table structure for `sys_freetime_booking_publish`
-- ----------------------------
DROP TABLE IF EXISTS `sys_freetime_booking_publish`;
CREATE TABLE `sys_freetime_booking_publish` (
  `TID` varchar(32) NOT NULL,
  `DOCTOR_ID` varchar(32) DEFAULT NULL,
  `FREESTART` datetime DEFAULT NULL,
  `FREEEND` datetime DEFAULT NULL,
  `FREECOUNT` int(11) DEFAULT NULL,
  `GROUPPRICE` decimal(9,1) DEFAULT NULL COMMENT '2人团价',
  `VIPPRICE` decimal(9,1) DEFAULT NULL COMMENT '贵宾价',
  `PUBLISHDATE` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`TID`),
  KEY `DOCTOR_ID` (`DOCTOR_ID`),
  CONSTRAINT `dock_booking_fk` FOREIGN KEY (`DOCTOR_ID`) REFERENCES `sys_doctor` (`DOCTOR_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `sys_hospital`
-- ----------------------------
DROP TABLE IF EXISTS `sys_hospital`;
CREATE TABLE `sys_hospital` (
  `HOSPITAL_ID` varchar(32) NOT NULL,
  `HOSPITALNAME` varchar(100) NOT NULL,
  `ADDRESS` varchar(255) DEFAULT NULL,
  `POSTALCODE` varchar(15) DEFAULT NULL,
  `FAX` varchar(30) DEFAULT NULL,
  `TELEPHONE` varchar(30) DEFAULT NULL,
  `DIQU_ID` varchar(32) DEFAULT NULL,
  `DESCRIPTION` varchar(255) DEFAULT NULL,
  `RCDSTS` char(1) NOT NULL,
  `RCDTEMSTEMP` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `REMARK` varchar(255) DEFAULT NULL,
  `LEVEL` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`HOSPITAL_ID`),
  KEY `DIQU_ID` (`DIQU_ID`),
  CONSTRAINT `DICU_ID_REF` FOREIGN KEY (`DIQU_ID`) REFERENCES `sys_dictionaries` (`DICTIONARIES_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sys_hospital`
-- ----------------------------
BEGIN;
INSERT INTO `sys_hospital` VALUES ('4d543a64e7b944a695d7558da953b21d', '广东省第二人民医院', '石榴岗320号', '5103102', '111111112', '12345678922', 'bbd36c2e3e244e2c94f9a8630a010d8d', 'good hospital2', 'A', '2017-06-24 22:20:37', 'good2', '4a296986db6f49a78d19db84b180e8b7'), ('4f62db1b57b144f0a2220ba1623ae74d', '广东省人民医院', '先烈中路', '510310', '2222222', '13416144628', 'a8f541ba1fcb49e4973d748376e7b566', '广州最好的综合性医院', 'A', '2017-07-17 20:34:56', '无', '0fa1047bb7674f00b18801f0ba3c4dea');
COMMIT;

-- ----------------------------
--  Table structure for `sys_medica`
-- ----------------------------
DROP TABLE IF EXISTS `sys_medica`;
CREATE TABLE `sys_medica` (
  `MEDICA_ID` varchar(32) NOT NULL,
  `MEDICANAME` varchar(100) NOT NULL,
  `PRODUCER` varchar(100) DEFAULT NULL,
  `PIC` varchar(100) DEFAULT NULL COMMENT '图片名称',
  `GUIGE` varchar(30) DEFAULT NULL COMMENT '规格',
  `PICHI` varchar(30) DEFAULT NULL COMMENT '批次号',
  `ALLOWNUM` varchar(30) DEFAULT NULL COMMENT '批准文号',
  `USEFOR` varchar(200) DEFAULT NULL COMMENT '功能主治',
  `BADFOR` varchar(200) DEFAULT NULL COMMENT '禁忌',
  `BADRESPONSE` varchar(100) DEFAULT NULL COMMENT '不良反应',
  `EFFECTDATE` datetime DEFAULT NULL COMMENT '保质期',
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `PRICE` decimal(5,1) DEFAULT NULL,
  `RCDSTS` char(1) DEFAULT NULL,
  `PUBLISHER` varchar(32) DEFAULT NULL COMMENT '发布者',
  PRIMARY KEY (`MEDICA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sys_medica`
-- ----------------------------
BEGIN;
INSERT INTO `sys_medica` VALUES ('b6f96765dd704b79ac5e1289acdd7c5c', '感冒灵', '广州制药一厂a', null, '11', '1000', '123456', '感冒', '无', '无', '2017-08-31 00:00:00', 'no', '15.0', 'A', '1');
COMMIT;

-- ----------------------------
--  Table structure for `sys_menu`
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `MENU_ID` int(11) NOT NULL,
  `MENU_NAME` varchar(255) DEFAULT NULL,
  `MENU_URL` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(100) DEFAULT NULL,
  `MENU_ORDER` varchar(100) DEFAULT NULL,
  `MENU_ICON` varchar(60) DEFAULT NULL,
  `MENU_TYPE` varchar(10) DEFAULT NULL,
  `MENU_STATE` int(1) DEFAULT NULL,
  PRIMARY KEY (`MENU_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sys_menu`
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES ('1', '系统管理', '#', '0', '1', 'menu-icon fa fa-desktop blue', '2', '1'), ('2', '权限管理', '#', '1', '2', 'menu-icon fa fa-lock black', '1', '1'), ('6', '信息管理', '#', '0', '5', 'menu-icon fa fa-credit-card green', '2', '1'), ('7', '图片管理', '#', '6', '1', 'menu-icon fa fa-folder-o pink', '2', '0'), ('8', '性能监控', 'druid/index.html', '9', '8', 'menu-icon fa fa-tachometer red', '1', '1'), ('9', '系统工具', '#', '0', '3', 'menu-icon fa fa-cog black', '2', '0'), ('10', '接口测试', 'tool/interfaceTest.do', '9', '2', 'menu-icon fa fa-exchange green', '1', '1'), ('11', '发送邮件', 'tool/goSendEmail.do', '9', '3', 'menu-icon fa fa-envelope-o green', '1', '1'), ('12', '置二维码', 'tool/goTwoDimensionCode.do', '9', '4', 'menu-icon fa fa-barcode green', '1', '1'), ('14', '地图工具', 'tool/map.do', '9', '6', 'menu-icon fa fa-globe black', '1', '1'), ('15', '微信管理', '#', '0', '4', 'menu-icon fa fa-comments purple', '2', '1'), ('16', '文本回复', 'textmsg/list.do', '15', '2', 'menu-icon fa fa-comment green', '2', '1'), ('17', '应用命令', 'command/list.do', '15', '4', 'menu-icon fa fa-comment grey', '2', '1'), ('18', '图文回复', 'imgmsg/list.do', '15', '3', 'menu-icon fa fa-comment pink', '2', '1'), ('19', '关注回复', 'textmsg/goSubscribe.do', '15', '1', 'menu-icon fa fa-comment orange', '2', '1'), ('20', '在线管理', 'onlinemanager/list.do', '1', '4', 'menu-icon fa fa-laptop green', '1', '1'), ('21', '打印测试', 'tool/printTest.do', '9', '7', 'menu-icon fa fa-hdd-o grey', '1', '1'), ('36', '角色权限', 'role.do', '2', '1', 'menu-icon fa fa-key orange', '1', '1'), ('37', '按钮权限', 'buttonrights/list.do', '2', '2', 'menu-icon fa fa-key green', '1', '1'), ('44', '代码生成器', 'createCode/list.do', '9', '0', 'menu-icon fa fa-cogs brown', '1', '1'), ('48', '图表报表', ' tool/fusionchartsdemo.do', '9', '5', 'menu-icon fa fa-bar-chart-o black', '1', '1'), ('50', '站内信', 'fhsms/list.do', '6', '2', 'menu-icon fa fa-envelope green', '1', '1'), ('51', '图片列表', 'pictures/list.do', '7', '1', 'menu-icon fa fa-folder-open-o green', '1', '1'), ('52', '图片爬虫', 'pictures/goImageCrawler.do', '7', '2', 'menu-icon fa fa-cloud-download green', '1', '1'), ('53', '表单构建器', 'tool/goFormbuilder.do', '9', '1', 'menu-icon fa fa-leaf black', '1', '1'), ('54', '数据库管理', '#', '0', '9', 'menu-icon fa fa-hdd-o blue', '2', '0'), ('55', '数据库备份', 'brdb/listAllTable.do', '54', '1', 'menu-icon fa fa-cloud-upload blue', '1', '1'), ('56', '数据库还原', 'brdb/list.do', '54', '3', 'menu-icon fa fa-cloud-download blue', '1', '1'), ('57', '备份定时器', 'timingbackup/list.do', '54', '2', 'menu-icon fa fa-tachometer blue', '1', '1'), ('58', 'SQL编辑器', 'sqledit/view.do', '54', '4', 'menu-icon fa fa-pencil-square-o blue', '1', '1'), ('59', 'OA办公', '#', '0', '6', 'menu-icon fa fa-laptop pink', '2', '0'), ('60', '组织机构', 'department/listAllDepartment.do?DEPARTMENT_ID=0', '59', '1', 'menu-icon fa fa-users green', '1', '1'), ('61', '信息发布', '#', '0', '10', 'menu-icon fa fa-cloud-upload black', '2', '1'), ('62', '闲时就医', 'doctor/publishfreeList.do', '61', '4', 'menu-icon fa  fa-coffee orange', '1', '1'), ('63', '加号信息', 'doctor/publishadditionList.do', '61', '1', 'menu-icon fa fa-bullhorn brown', '1', '1'), ('72', '用户管理', '#', '1', '1', 'menu-icon fa fa-users blue', '1', '1'), ('73', '基础数据', '#', '1', '3', 'menu-icon fa fa-folder blue', '1', '1'), ('74', '系统用户', 'user/listUsers.do', '72', '1', 'menu-icon fa fa-users green', '1', '1'), ('75', '患者用户', 'userinfo/list.do', '72', '2', 'menu-icon fa fa-users red', '1', '1'), ('76', '菜单管理', 'menu/listAllMenu.do', '73', '4', 'menu-icon fa fa-folder-open-o red', '1', '1'), ('77', '按钮管理', 'fhbutton/list.do', '73', '5', 'menu-icon fa fa-download brown', '1', '1'), ('78', '杂项维护', 'dictionaries/listAllDict.do?DICTIONARIES_ID=0', '73', '11', 'menu-icon fa fa-book purple', '1', '1'), ('79', '医院管理', 'hospital/getlist.do', '73', '1', 'menu-icon fa fa-heart-o red', '1', '1'), ('80', '科室管理', 'category/getlist.do', '73', '2', 'menu-icon fa fa-flask red', '1', '1'), ('81', '我的订单', '#', '0', '11', 'menu-icon fa fa-download red', '2', '1'), ('82', '订单', 'doctor/myorder.do', '81', '1', 'menu-icon fa fa-gavel brown', '1', '1'), ('83', 'B超预约', 'doctor/bcBooking.do', '61', '3', 'menu-icon fa fa-leaf black', '1', '1'), ('84', '药品管理', '#', '0', '2', 'menu-icon fa fa-leaf black', '2', '1'), ('85', '药品管理', 'medical/getlist.do', '84', '1', 'menu-icon fa fa-asterisk green', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `sys_role`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `ROLE_ID` varchar(100) NOT NULL,
  `ROLE_NAME` varchar(100) DEFAULT NULL,
  `RIGHTS` varchar(255) DEFAULT NULL,
  `PARENT_ID` varchar(100) DEFAULT NULL,
  `ADD_QX` varchar(255) DEFAULT NULL,
  `DEL_QX` varchar(255) DEFAULT NULL,
  `EDIT_QX` varchar(255) DEFAULT NULL,
  `CHA_QX` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ROLE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sys_role`
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES ('1', '系统管理组', '60441570919264971722317766', '0', '1', '1', '1', '1'), ('2', '医生组', '74953416957008073327640576', '0', '0', '0', '0', '1'), ('3', '医生', '74953416957008073327640576', '2', '74953416957008073327640576', '74953416957008073327640576', '74953416957008073327640576', '74953416957008073327640576'), ('3264c8e83d0248bb9e3ea6195b4c0216', '系统管理员', '60441570919264971722317766', '1', '60441570919264971722317766', '60441570919264971722317766', '60441570919264971722317766', '77366548534770844664061894'), ('46294b31a71c4600801724a6eb06bb26', '会员组', '', '0', '0', '0', '0', '0'), ('c21cecf84048434b93383182b1d98cba', '普通会员', '', '46294b31a71c4600801724a6eb06bb26', '0', '0', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `sys_role_fhbutton`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_fhbutton`;
CREATE TABLE `sys_role_fhbutton` (
  `RB_ID` varchar(100) NOT NULL,
  `ROLE_ID` varchar(100) DEFAULT NULL,
  `BUTTON_ID` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`RB_ID`),
  KEY `角色表外键` (`ROLE_ID`) USING BTREE,
  KEY `fbutton` (`BUTTON_ID`) USING BTREE,
  CONSTRAINT `sys_role_fhbutton_ibfk_1` FOREIGN KEY (`BUTTON_ID`) REFERENCES `sys_fhbutton` (`FHBUTTON_ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `sys_role_fhbutton_ibfk_2` FOREIGN KEY (`ROLE_ID`) REFERENCES `sys_role` (`ROLE_ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sys_role_fhbutton`
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_fhbutton` VALUES ('04b1a6cd6c2c4d5e81db9b16a5e91eab', '3264c8e83d0248bb9e3ea6195b4c0216', '46992ea280ba4b72b29dedb0d4bc0106'), ('0b7f305c1268428b8e7e01672185f103', '3', 'da7fd386de0b49ce809984f5919022b8'), ('8221f7befb144801b1d17b9f96ceb073', '3', 'cc51b694d5344d28a9aa13c84b7166cd'), ('ad3c127151834b5ea3747ca84ad01b46', '3264c8e83d0248bb9e3ea6195b4c0216', 'da7fd386de0b49ce809984f5919022b8'), ('b622d9b9186a48028c654ee6e5a848f6', '3', '4efa162fce8340f0bd2dcd3b11d327ec'), ('cbcfdc573fb445348da147b3155e710b', '3264c8e83d0248bb9e3ea6195b4c0216', '4efa162fce8340f0bd2dcd3b11d327ec'), ('ddd080dda53a471bb90f5e98f4b33558', '3264c8e83d0248bb9e3ea6195b4c0216', 'cc51b694d5344d28a9aa13c84b7166cd'), ('e50db062b0484df89e29211bd4e6a13c', '3', '46992ea280ba4b72b29dedb0d4bc0106'), ('f642090589b64612a6046c2ba5316883', '3', '3542adfbda73410c976e185ffe50ad06'), ('fac01b8810d3403ea8e36875d9cbf785', '3264c8e83d0248bb9e3ea6195b4c0216', '3542adfbda73410c976e185ffe50ad06');
COMMIT;

-- ----------------------------
--  Table structure for `sys_user`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `USER_ID` varchar(100) NOT NULL,
  `USERNAME` varchar(255) DEFAULT NULL,
  `PASSWORD` varchar(255) DEFAULT NULL,
  `NAME` varchar(255) DEFAULT NULL,
  `RIGHTS` varchar(255) DEFAULT NULL,
  `ROLE_ID` varchar(100) DEFAULT NULL,
  `LAST_LOGIN` varchar(255) DEFAULT NULL,
  `IP` varchar(100) DEFAULT NULL,
  `STATUS` char(1) DEFAULT NULL,
  `BZ` varchar(255) DEFAULT NULL,
  `SKIN` varchar(100) DEFAULT NULL,
  `EMAIL` varchar(32) DEFAULT NULL,
  `NUMBER` varchar(100) DEFAULT NULL,
  `PHONE` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sys_user`
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES ('1', 'admin', 'de41b7fb99201d8334c23c014db35ecd92df81bc', 'admin', '', '3264c8e83d0248bb9e3ea6195b4c0216', '2017-09-10 22:10:06', '0:0:0:0:0:0:0:1', '0', 'admin', 'default', '309823611@qq.com', '001', '13570338323'), ('4c97b4d20fcf4fa28969e5326257a212', 'sunshine', '8ac76e2f86adc4761b3b2f34ddb0f25d89217602', 'sam', '', '3', '2017-09-01 21:39:18', '0:0:0:0:0:0:0:1', '0', 'doctor', 'default', 'mshwu@163.com', '002', '13416144628');
COMMIT;

-- ----------------------------
--  Table structure for `sys_xcx_normal_user`
-- ----------------------------
DROP TABLE IF EXISTS `sys_xcx_normal_user`;
CREATE TABLE `sys_xcx_normal_user` (
  `UID` varchar(32) NOT NULL,
  `OPENID` varchar(32) NOT NULL,
  `PID` varchar(18) NOT NULL,
  `NAME` varchar(255) DEFAULT NULL,
  `VIP` char(1) DEFAULT NULL,
  `VIPEXPIRE` datetime DEFAULT NULL COMMENT 'VIP过期',
  `PHONE` varchar(100) DEFAULT NULL,
  `EMAIL` varchar(32) DEFAULT NULL,
  `RCDSTS` char(1) NOT NULL DEFAULT 'A',
  `RCDATE` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`UID`),
  KEY `OPENID` (`OPENID`),
  CONSTRAINT `openid_ref_fk` FOREIGN KEY (`OPENID`) REFERENCES `xcx_user_manager` (`OPENID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sys_xcx_normal_user`
-- ----------------------------
BEGIN;
INSERT INTO `sys_xcx_normal_user` VALUES ('34cd12b2f8aa45e3b05f0d1d9261c916', 'oodUY0cQIhlGgIAC7WSKgRUz60RQ', '445224198204153952', 'sam', 'N', null, '13416144628', 'mshwu@163.com', 'A', '2017-07-19 21:46:17');
COMMIT;

-- ----------------------------
--  Table structure for `tb_pictures`
-- ----------------------------
DROP TABLE IF EXISTS `tb_pictures`;
CREATE TABLE `tb_pictures` (
  `PICTURES_ID` varchar(100) NOT NULL,
  `TITLE` varchar(255) DEFAULT NULL COMMENT '标题',
  `NAME` varchar(255) DEFAULT NULL COMMENT '文件名',
  `PATH` varchar(255) DEFAULT NULL COMMENT '路径',
  `CREATETIME` varchar(100) DEFAULT NULL COMMENT '创建时间',
  `MASTER_ID` varchar(255) DEFAULT NULL COMMENT '属于',
  `BZ` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`PICTURES_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `weixin_command`
-- ----------------------------
DROP TABLE IF EXISTS `weixin_command`;
CREATE TABLE `weixin_command` (
  `COMMAND_ID` varchar(100) NOT NULL,
  `KEYWORD` varchar(255) DEFAULT NULL COMMENT '关键词',
  `COMMANDCODE` varchar(255) DEFAULT NULL COMMENT '应用路径',
  `CREATETIME` varchar(255) DEFAULT NULL COMMENT '创建时间',
  `STATUS` int(1) NOT NULL COMMENT '状态',
  `BZ` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`COMMAND_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `weixin_command`
-- ----------------------------
BEGIN;
INSERT INTO `weixin_command` VALUES ('2636750f6978451b8330874c9be042c2', '锁定服务器', 'rundll32.exe user32.dll,LockWorkStation', '2015-05-10 21:25:06', '1', '锁定计算机'), ('46217c6d44354010823241ef484f7214', '打开浏览器', 'C:/Program Files/Internet Explorer/iexplore.exe', '2015-05-09 02:43:02', '1', '打开浏览器操作'), ('576adcecce504bf3bb34c6b4da79a177', '关闭浏览器', 'taskkill /f /im iexplore.exe', '2015-05-09 02:36:48', '2', '关闭浏览器操作'), ('854a157c6d99499493f4cc303674c01f', '关闭QQ', 'taskkill /f /im qq.exe', '2015-05-10 21:25:46', '1', '关闭QQ'), ('ab3a8c6310ca4dc8b803ecc547e55ae7', '打开QQ', 'D:/SOFT/QQ/QQ/Bin/qq.exe', '2015-05-10 21:25:25', '1', '打开QQ');
COMMIT;

-- ----------------------------
--  Table structure for `weixin_imgmsg`
-- ----------------------------
DROP TABLE IF EXISTS `weixin_imgmsg`;
CREATE TABLE `weixin_imgmsg` (
  `IMGMSG_ID` varchar(100) NOT NULL,
  `KEYWORD` varchar(255) DEFAULT NULL COMMENT '关键词',
  `CREATETIME` varchar(100) DEFAULT NULL COMMENT '创建时间',
  `STATUS` int(11) NOT NULL COMMENT '状态',
  `BZ` varchar(255) DEFAULT NULL COMMENT '备注',
  `TITLE1` varchar(255) DEFAULT NULL COMMENT '标题1',
  `DESCRIPTION1` varchar(255) DEFAULT NULL COMMENT '描述1',
  `IMGURL1` varchar(255) DEFAULT NULL COMMENT '图片地址1',
  `TOURL1` varchar(255) DEFAULT NULL COMMENT '超链接1',
  `TITLE2` varchar(255) DEFAULT NULL COMMENT '标题2',
  `DESCRIPTION2` varchar(255) DEFAULT NULL COMMENT '描述2',
  `IMGURL2` varchar(255) DEFAULT NULL COMMENT '图片地址2',
  `TOURL2` varchar(255) DEFAULT NULL COMMENT '超链接2',
  `TITLE3` varchar(255) DEFAULT NULL COMMENT '标题3',
  `DESCRIPTION3` varchar(255) DEFAULT NULL COMMENT '描述3',
  `IMGURL3` varchar(255) DEFAULT NULL COMMENT '图片地址3',
  `TOURL3` varchar(255) DEFAULT NULL COMMENT '超链接3',
  `TITLE4` varchar(255) DEFAULT NULL COMMENT '标题4',
  `DESCRIPTION4` varchar(255) DEFAULT NULL COMMENT '描述4',
  `IMGURL4` varchar(255) DEFAULT NULL COMMENT '图片地址4',
  `TOURL4` varchar(255) DEFAULT NULL COMMENT '超链接4',
  `TITLE5` varchar(255) DEFAULT NULL COMMENT '标题5',
  `DESCRIPTION5` varchar(255) DEFAULT NULL COMMENT '描述5',
  `IMGURL5` varchar(255) DEFAULT NULL COMMENT '图片地址5',
  `TOURL5` varchar(255) DEFAULT NULL COMMENT '超链接5',
  `TITLE6` varchar(255) DEFAULT NULL COMMENT '标题6',
  `DESCRIPTION6` varchar(255) DEFAULT NULL COMMENT '描述6',
  `IMGURL6` varchar(255) DEFAULT NULL COMMENT '图片地址6',
  `TOURL6` varchar(255) DEFAULT NULL COMMENT '超链接6',
  `TITLE7` varchar(255) DEFAULT NULL COMMENT '标题7',
  `DESCRIPTION7` varchar(255) DEFAULT NULL COMMENT '描述7',
  `IMGURL7` varchar(255) DEFAULT NULL COMMENT '图片地址7',
  `TOURL7` varchar(255) DEFAULT NULL COMMENT '超链接7',
  `TITLE8` varchar(255) DEFAULT NULL COMMENT '标题8',
  `DESCRIPTION8` varchar(255) DEFAULT NULL COMMENT '描述8',
  `IMGURL8` varchar(255) DEFAULT NULL COMMENT '图片地址8',
  `TOURL8` varchar(255) DEFAULT NULL COMMENT '超链接8',
  PRIMARY KEY (`IMGMSG_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `weixin_imgmsg`
-- ----------------------------
BEGIN;
INSERT INTO `weixin_imgmsg` VALUES ('380b2cb1f4954315b0e20618f7b5bd8f', '首页', '2015-05-10 20:51:09', '1', '图文回复', '图文回复标题', '图文回复描述', 'http://a.hiphotos.baidu.com/image/h%3D360/sign=c6c7e73ebc389b5027ffe654b535e5f1/a686c9177f3e6709392bb8df3ec79f3df8dc55e3.jpg', 'www.baidu.com', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
COMMIT;

-- ----------------------------
--  Table structure for `weixin_textmsg`
-- ----------------------------
DROP TABLE IF EXISTS `weixin_textmsg`;
CREATE TABLE `weixin_textmsg` (
  `TEXTMSG_ID` varchar(100) NOT NULL,
  `KEYWORD` varchar(255) DEFAULT NULL COMMENT '关键词',
  `CONTENT` varchar(255) DEFAULT NULL COMMENT '内容',
  `CREATETIME` varchar(100) DEFAULT NULL COMMENT '创建时间',
  `STATUS` int(2) DEFAULT NULL COMMENT '状态',
  `BZ` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`TEXTMSG_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `weixin_textmsg`
-- ----------------------------
BEGIN;
INSERT INTO `weixin_textmsg` VALUES ('695cd74779734231928a253107ab0eeb', '吃饭', '吃了噢噢噢噢', '2015-05-10 22:52:27', '1', '文本回复'), ('d4738af7aea74a6ca1a5fb25a98f9acb', '关注', '这里是关注后回复的内容', '2015-05-11 02:12:36', '1', '关注回复');
COMMIT;

-- ----------------------------
--  Table structure for `xcx_session_manager`
-- ----------------------------
DROP TABLE IF EXISTS `xcx_session_manager`;
CREATE TABLE `xcx_session_manager` (
  `3TDSESSION` varchar(128) NOT NULL,
  `OPENID` varchar(32) DEFAULT NULL,
  `SESSION_KEY` varchar(32) DEFAULT NULL,
  `EXPIRE` datetime DEFAULT NULL,
  PRIMARY KEY (`3TDSESSION`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `xcx_session_manager`
-- ----------------------------
BEGIN;
INSERT INTO `xcx_session_manager` VALUES ('ZDZhYzJkMDQzNjRhYTA3NjIzNzI5ODVjZjk4YzU2MjQ=', 'oodUY0cQIhlGgIAC7WSKgRUz60RQ', 'YAA0yHraT4D84fKC6JSoaw==', '2017-09-10 23:05:10');
COMMIT;

-- ----------------------------
--  Table structure for `xcx_user_manager`
-- ----------------------------
DROP TABLE IF EXISTS `xcx_user_manager`;
CREATE TABLE `xcx_user_manager` (
  `OPENID` varchar(32) NOT NULL,
  `PASSWORD` varchar(255) DEFAULT NULL,
  `USERTYPE` char(1) DEFAULT NULL COMMENT '0-未确定身份 1-普通用户  2-医生  ',
  `PIC` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`OPENID`),
  KEY `OPENID` (`OPENID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `xcx_user_manager`
-- ----------------------------
BEGIN;
INSERT INTO `xcx_user_manager` VALUES ('oodUY0cQIhlGgIAC7WSKgRUz60RQ', 'oodUY0cQIhlGgIAC7WSKgRUz60RQ', '2', 'https://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTI0vMKKOxKsvul23zbjKEBibu8ibFEDkPlXD9HpjmrPKaHP2zHrQrjCCdtrtgTeBL4JyT0cEHD5CFlg/0');
COMMIT;

-- ----------------------------
--  Function structure for `getHospitalAddIDS`
-- ----------------------------
DROP FUNCTION IF EXISTS `getHospitalAddIDS`;
delimiter ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `getHospitalAddIDS`(D_ID varchar(32)) RETURNS varchar(100) CHARSET utf8
    DETERMINISTIC
BEGIN
DECLARE ADDRESSID VARCHAR(100) DEFAULT '';
DECLARE SBIANMA  VARCHAR(50);
DECLARE H_ID   VARCHAR(32);
DECLARE P_ID   VARCHAR(32);


	SELECT BIANMA,PARENT_ID, DICTIONARIES_ID INTO SBIANMA,P_ID,H_ID FROM sys_dictionaries
	WHERE DICTIONARIES_ID = D_ID;


	WHILE (SBIANMA<>'003') DO
			 
		SET ADDRESSID = CONCAT(ADDRESSID,REVERSE(H_ID),',');

		SELECT BIANMA,PARENT_ID,DICTIONARIES_ID INTO SBIANMA,P_ID,H_ID FROM sys_dictionaries
		WHERE DICTIONARIES_ID = P_ID;

	END WHILE;


RETURN RIGHT(REVERSE(ADDRESSID),LENGTH(ADDRESSID)-1);

END
 ;;
delimiter ;

-- ----------------------------
--  Function structure for `getHospitalAddress`
-- ----------------------------
DROP FUNCTION IF EXISTS `getHospitalAddress`;
delimiter ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `getHospitalAddress`(D_ID varchar(32)) RETURNS varchar(500) CHARSET utf8
    DETERMINISTIC
BEGIN
DECLARE ADDRESS VARCHAR(500) DEFAULT '';
DECLARE SBIANMA  VARCHAR(50);
DECLARE VNAME  VARCHAR(30);
DECLARE P_ID   VARCHAR(32);
DECLARE PA_ID  VARCHAR(32);

	SET ADDRESS='';
	SELECT BIANMA,PARENT_ID,`NAME` INTO SBIANMA,P_ID,VNAME FROM sys_dictionaries
	WHERE DICTIONARIES_ID = D_ID;

	WHILE (SBIANMA!='003') DO
			 
		SET ADDRESS = CONCAT(ADDRESS,REVERSE(VNAME));
		SET PA_ID = P_ID;

		SELECT BIANMA,PARENT_ID,`NAME` INTO SBIANMA,P_ID,VNAME FROM sys_dictionaries
		WHERE DICTIONARIES_ID = PA_ID;
		  
	END WHILE;


RETURN REVERSE(ADDRESS);

END
 ;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;
